Dataset statistics
| Number of variables | 44 |
|---|---|
| Number of observations | 115037 |
| Missing cells | 171246 |
| Missing cells (%) | 3.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 38.6 MiB |
| Average record size in memory | 352.0 B |
Variable types
| Categorical | 25 |
|---|---|
| Numeric | 19 |
order_id has a high cardinality: 96036 distinct values | High cardinality |
customer_id has a high cardinality: 96036 distinct values | High cardinality |
order_purchase_timestamp has a high cardinality: 95515 distinct values | High cardinality |
order_approved_at has a high cardinality: 87916 distinct values | High cardinality |
order_delivered_carrier_date has a high cardinality: 78867 distinct values | High cardinality |
order_delivered_customer_date has a high cardinality: 93239 distinct values | High cardinality |
order_estimated_delivery_date has a high cardinality: 449 distinct values | High cardinality |
product_id has a high cardinality: 32063 distinct values | High cardinality |
seller_id has a high cardinality: 3021 distinct values | High cardinality |
shipping_limit_date has a high cardinality: 90958 distinct values | High cardinality |
seller_city has a high cardinality: 604 distinct values | High cardinality |
customer_unique_id has a high cardinality: 92939 distinct values | High cardinality |
customer_city has a high cardinality: 4044 distinct values | High cardinality |
product_category_name has a high cardinality: 71 distinct values | High cardinality |
product_category_name_english has a high cardinality: 71 distinct values | High cardinality |
review_id has a high cardinality: 95840 distinct values | High cardinality |
review_comment_title has a high cardinality: 4455 distinct values | High cardinality |
review_comment_message has a high cardinality: 35020 distinct values | High cardinality |
review_creation_date has a high cardinality: 632 distinct values | High cardinality |
review_answer_timestamp has a high cardinality: 95685 distinct values | High cardinality |
price is highly correlated with product_weight_g and 1 other fields | High correlation |
product_weight_g is highly correlated with price and 3 other fields | High correlation |
product_length_cm is highly correlated with product_weight_g and 1 other fields | High correlation |
product_height_cm is highly correlated with product_weight_g | High correlation |
product_width_cm is highly correlated with product_weight_g and 1 other fields | High correlation |
payment_value is highly correlated with price | High correlation |
price is highly correlated with payment_value | High correlation |
freight_value is highly correlated with product_weight_g | High correlation |
product_weight_g is highly correlated with freight_value and 2 other fields | High correlation |
product_length_cm is highly correlated with product_width_cm | High correlation |
product_height_cm is highly correlated with product_weight_g | High correlation |
product_width_cm is highly correlated with product_weight_g and 1 other fields | High correlation |
payment_value is highly correlated with price | High correlation |
price is highly correlated with payment_value | High correlation |
payment_value is highly correlated with price | High correlation |
product_category_name is highly correlated with product_category_name_english | High correlation |
product_category_name_english is highly correlated with product_category_name | High correlation |
price is highly correlated with payment_value | High correlation |
seller_zip_code_prefix is highly correlated with seller_state and 4 other fields | High correlation |
seller_state is highly correlated with seller_zip_code_prefix and 4 other fields | High correlation |
customer_zip_code_prefix is highly correlated with customer_state and 2 other fields | High correlation |
customer_state is highly correlated with customer_zip_code_prefix and 2 other fields | High correlation |
product_category_name is highly correlated with seller_zip_code_prefix and 9 other fields | High correlation |
product_description_lenght is highly correlated with product_category_name and 1 other fields | High correlation |
product_weight_g is highly correlated with product_category_name and 1 other fields | High correlation |
product_length_cm is highly correlated with product_category_name and 2 other fields | High correlation |
product_height_cm is highly correlated with product_category_name and 1 other fields | High correlation |
product_width_cm is highly correlated with product_category_name and 2 other fields | High correlation |
payment_value is highly correlated with price | High correlation |
product_category_name_english is highly correlated with seller_zip_code_prefix and 9 other fields | High correlation |
geolocation_lat_customer is highly correlated with customer_zip_code_prefix and 2 other fields | High correlation |
geolocation_lng_customer is highly correlated with customer_zip_code_prefix and 2 other fields | High correlation |
geolocation_lat_seller is highly correlated with seller_zip_code_prefix and 4 other fields | High correlation |
geolocation_lng_seller is highly correlated with seller_zip_code_prefix and 4 other fields | High correlation |
order_delivered_carrier_date has 1185 (1.0%) missing values | Missing |
order_delivered_customer_date has 2384 (2.1%) missing values | Missing |
review_comment_title has 101302 (88.1%) missing values | Missing |
review_comment_message has 66357 (57.7%) missing values | Missing |
order_id is uniformly distributed | Uniform |
customer_id is uniformly distributed | Uniform |
order_purchase_timestamp is uniformly distributed | Uniform |
order_approved_at is uniformly distributed | Uniform |
order_delivered_customer_date is uniformly distributed | Uniform |
shipping_limit_date is uniformly distributed | Uniform |
customer_unique_id is uniformly distributed | Uniform |
review_id is uniformly distributed | Uniform |
review_answer_timestamp is uniformly distributed | Uniform |
Reproduction
| Analysis started | 2022-04-06 15:19:26.999147 |
|---|---|
| Analysis finished | 2022-04-06 15:21:52.952512 |
| Duration | 2 minutes and 25.95 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 96036 |
|---|---|
| Distinct (%) | 83.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| 895ab968e7bb0d5659d16cd74cd1650c | 63 |
|---|---|
| fedcd9f7ccdc8cba3a18defedd1a5547 | 38 |
| fa65dad1b0e818e3ccc5cb0e39231352 | 29 |
| ccf804e764ed5650cd8759557269dc13 | 26 |
| 465c2e1bee4561cb39e0db8c5993aafc | 24 |
| Other values (96031) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 83510 ? |
|---|---|
| Unique (%) | 72.6% |
Sample
| 1st row | e481f51cbdc54678b7cc49136f2d6af7 |
|---|---|
| 2nd row | e481f51cbdc54678b7cc49136f2d6af7 |
| 3rd row | e481f51cbdc54678b7cc49136f2d6af7 |
| 4th row | 128e10d95713541c87cd1a2e48201934 |
| 5th row | 0e7e841ddf8f8f2de2bad69267ecfbcf |
Common Values
| Value | Count | Frequency (%) |
| 895ab968e7bb0d5659d16cd74cd1650c | 63 | 0.1% |
| fedcd9f7ccdc8cba3a18defedd1a5547 | 38 | < 0.1% |
| fa65dad1b0e818e3ccc5cb0e39231352 | 29 | < 0.1% |
| ccf804e764ed5650cd8759557269dc13 | 26 | < 0.1% |
| 465c2e1bee4561cb39e0db8c5993aafc | 24 | < 0.1% |
| 68986e4324f6a21481df4e6e89abcf01 | 24 | < 0.1% |
| a3725dfe487d359b5be08cac48b64ec5 | 24 | < 0.1% |
| c6492b842ac190db807c15aff21a7dd6 | 24 | < 0.1% |
| 6d58638e32674bebee793a47ac4cbadc | 24 | < 0.1% |
| 5a3b1c29a49756e75f1ef513383c0c12 | 22 | < 0.1% |
| Other values (96026) | 114739 |
Length
| Value | Count | Frequency (%) |
| 895ab968e7bb0d5659d16cd74cd1650c | 63 | 0.1% |
| fedcd9f7ccdc8cba3a18defedd1a5547 | 38 | < 0.1% |
| fa65dad1b0e818e3ccc5cb0e39231352 | 29 | < 0.1% |
| ccf804e764ed5650cd8759557269dc13 | 26 | < 0.1% |
| 465c2e1bee4561cb39e0db8c5993aafc | 24 | < 0.1% |
| 68986e4324f6a21481df4e6e89abcf01 | 24 | < 0.1% |
| a3725dfe487d359b5be08cac48b64ec5 | 24 | < 0.1% |
| c6492b842ac190db807c15aff21a7dd6 | 24 | < 0.1% |
| 6d58638e32674bebee793a47ac4cbadc | 24 | < 0.1% |
| 5a3b1c29a49756e75f1ef513383c0c12 | 22 | < 0.1% |
| Other values (96026) | 114739 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 96036 |
|---|---|
| Distinct (%) | 83.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| 270c23a11d024a44c896d1894b261a83 | 63 |
|---|---|
| 13aa59158da63ba0e93ec6ac2c07aacb | 38 |
| 9af2372a1e49340278e7c1ef8d749f34 | 29 |
| 92cd3ec6e2d643d4ebd0e3d6238f69e2 | 26 |
| 63b964e79dee32a3587651701a2b8dbf | 24 |
| Other values (96031) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 83510 ? |
|---|---|
| Unique (%) | 72.6% |
Sample
| 1st row | 9ef432eb6251297304e76186b10a928d |
|---|---|
| 2nd row | 9ef432eb6251297304e76186b10a928d |
| 3rd row | 9ef432eb6251297304e76186b10a928d |
| 4th row | a20e8105f23924cd00833fd87daa0831 |
| 5th row | 26c7ac168e1433912a51b924fbd34d34 |
Common Values
| Value | Count | Frequency (%) |
| 270c23a11d024a44c896d1894b261a83 | 63 | 0.1% |
| 13aa59158da63ba0e93ec6ac2c07aacb | 38 | < 0.1% |
| 9af2372a1e49340278e7c1ef8d749f34 | 29 | < 0.1% |
| 92cd3ec6e2d643d4ebd0e3d6238f69e2 | 26 | < 0.1% |
| 63b964e79dee32a3587651701a2b8dbf | 24 | < 0.1% |
| 86cc80fef09f7f39df4b0dbce48e81cb | 24 | < 0.1% |
| d22f25a9fadfb1abbc2e29395b1239f4 | 24 | < 0.1% |
| 6ee2f17e3b6c33d6a9557f280edd2925 | 24 | < 0.1% |
| 2ba91e12e5e4c9f56b82b86d9031d329 | 24 | < 0.1% |
| be1c4e52bb71e0c54b11a26b8e8d59f2 | 22 | < 0.1% |
| Other values (96026) | 114739 |
Length
| Value | Count | Frequency (%) |
| 270c23a11d024a44c896d1894b261a83 | 63 | 0.1% |
| 13aa59158da63ba0e93ec6ac2c07aacb | 38 | < 0.1% |
| 9af2372a1e49340278e7c1ef8d749f34 | 29 | < 0.1% |
| 92cd3ec6e2d643d4ebd0e3d6238f69e2 | 26 | < 0.1% |
| 63b964e79dee32a3587651701a2b8dbf | 24 | < 0.1% |
| 86cc80fef09f7f39df4b0dbce48e81cb | 24 | < 0.1% |
| d22f25a9fadfb1abbc2e29395b1239f4 | 24 | < 0.1% |
| 6ee2f17e3b6c33d6a9557f280edd2925 | 24 | < 0.1% |
| 2ba91e12e5e4c9f56b82b86d9031d329 | 24 | < 0.1% |
| be1c4e52bb71e0c54b11a26b8e8d59f2 | 22 | < 0.1% |
| Other values (96026) | 114739 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
order_status
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| delivered | |
|---|---|
| shipped | 1132 |
| canceled | 530 |
| processing | 356 |
| invoiced | 355 |
| Other values (2) | 10 |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 8.975816476 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | delivered |
|---|---|
| 2nd row | delivered |
| 3rd row | delivered |
| 4th row | delivered |
| 5th row | delivered |
Common Values
| Value | Count | Frequency (%) |
| delivered | 112654 | |
| shipped | 1132 | 1.0% |
| canceled | 530 | 0.5% |
| processing | 356 | 0.3% |
| invoiced | 355 | 0.3% |
| unavailable | 7 | < 0.1% |
| approved | 3 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| delivered | 112654 | |
| shipped | 1132 | 1.0% |
| canceled | 530 | 0.5% |
| processing | 356 | 0.3% |
| invoiced | 355 | 0.3% |
| unavailable | 7 | < 0.1% |
| approved | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 95515 |
|---|---|
| Distinct (%) | 83.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| 2017-08-08 20:26:31 | 63 |
|---|---|
| 2017-09-23 14:56:45 | 38 |
| 2017-04-20 12:45:34 | 29 |
| 2017-06-07 12:05:10 | 26 |
| 2017-03-09 23:39:26 | 24 |
| Other values (95510) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 82735 ? |
|---|---|
| Unique (%) | 71.9% |
Sample
| 1st row | 2017-10-02 10:56:33 |
|---|---|
| 2nd row | 2017-10-02 10:56:33 |
| 3rd row | 2017-10-02 10:56:33 |
| 4th row | 2017-08-15 18:29:31 |
| 5th row | 2017-08-02 18:24:47 |
Common Values
| Value | Count | Frequency (%) |
| 2017-08-08 20:26:31 | 63 | 0.1% |
| 2017-09-23 14:56:45 | 38 | < 0.1% |
| 2017-04-20 12:45:34 | 29 | < 0.1% |
| 2017-06-07 12:05:10 | 26 | < 0.1% |
| 2017-03-09 23:39:26 | 24 | < 0.1% |
| 2018-05-12 12:28:58 | 24 | < 0.1% |
| 2017-07-07 14:55:43 | 24 | < 0.1% |
| 2017-11-25 13:54:39 | 24 | < 0.1% |
| 2018-02-14 16:34:27 | 24 | < 0.1% |
| 2017-12-08 12:00:04 | 22 | < 0.1% |
| Other values (95505) | 114739 |
Length
| Value | Count | Frequency (%) |
| 2017-11-24 | 1394 | 0.6% |
| 2017-11-25 | 621 | 0.3% |
| 2017-11-27 | 491 | 0.2% |
| 2017-11-26 | 467 | 0.2% |
| 2018-08-06 | 441 | 0.2% |
| 2017-11-28 | 438 | 0.2% |
| 2018-08-07 | 433 | 0.2% |
| 2018-05-15 | 432 | 0.2% |
| 2018-05-07 | 422 | 0.2% |
| 2018-05-14 | 420 | 0.2% |
| Other values (50661) | 224515 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 87916 |
|---|---|
| Distinct (%) | 76.4% |
| Missing | 14 |
| Missing (%) | < 0.1% |
| Memory size | 898.9 KiB |
| 2017-08-08 20:43:31 | 63 |
|---|---|
| 2017-09-25 17:44:41 | 38 |
| 2017-04-22 09:10:13 | 29 |
| 2017-06-09 16:15:08 | 26 |
| 2017-07-07 15:10:17 | 24 |
| Other values (87911) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 70486 ? |
|---|---|
| Unique (%) | 61.3% |
Sample
| 1st row | 2017-10-02 11:07:15 |
|---|---|
| 2nd row | 2017-10-02 11:07:15 |
| 3rd row | 2017-10-02 11:07:15 |
| 4th row | 2017-08-15 20:05:16 |
| 5th row | 2017-08-02 18:43:15 |
Common Values
| Value | Count | Frequency (%) |
| 2017-08-08 20:43:31 | 63 | 0.1% |
| 2017-09-25 17:44:41 | 38 | < 0.1% |
| 2017-04-22 09:10:13 | 29 | < 0.1% |
| 2017-06-09 16:15:08 | 26 | < 0.1% |
| 2017-07-07 15:10:17 | 24 | < 0.1% |
| 2018-05-12 15:41:58 | 24 | < 0.1% |
| 2017-03-09 23:39:26 | 24 | < 0.1% |
| 2018-02-21 12:28:15 | 24 | < 0.1% |
| 2017-11-25 14:16:34 | 24 | < 0.1% |
| 2018-02-24 03:20:27 | 23 | < 0.1% |
| Other values (87906) | 114724 |
Length
| Value | Count | Frequency (%) |
| 2018-04-24 | 1140 | 0.5% |
| 2017-11-24 | 974 | 0.4% |
| 2017-11-25 | 910 | 0.4% |
| 2018-07-05 | 814 | 0.4% |
| 2017-11-28 | 586 | 0.3% |
| 2018-08-07 | 500 | 0.2% |
| 2018-05-08 | 487 | 0.2% |
| 2018-08-20 | 480 | 0.2% |
| 2018-05-01 | 477 | 0.2% |
| 2017-12-05 | 467 | 0.2% |
| Other values (41645) | 223211 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 78867 |
|---|---|
| Distinct (%) | 69.3% |
| Missing | 1185 |
| Missing (%) | 1.0% |
| Memory size | 898.9 KiB |
| 2017-08-10 11:58:14 | 63 |
|---|---|
| 2018-05-09 15:48:00 | 48 |
| 2017-10-02 23:47:54 | 38 |
| 2018-05-10 18:29:00 | 35 |
| 2018-05-14 14:25:00 | 32 |
| Other values (78862) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 59777 ? |
|---|---|
| Unique (%) | 52.5% |
Sample
| 1st row | 2017-10-04 19:55:00 |
|---|---|
| 2nd row | 2017-10-04 19:55:00 |
| 3rd row | 2017-10-04 19:55:00 |
| 4th row | 2017-08-17 15:28:33 |
| 5th row | 2017-08-04 17:35:43 |
Common Values
| Value | Count | Frequency (%) |
| 2017-08-10 11:58:14 | 63 | 0.1% |
| 2018-05-09 15:48:00 | 48 | < 0.1% |
| 2017-10-02 23:47:54 | 38 | < 0.1% |
| 2018-05-10 18:29:00 | 35 | < 0.1% |
| 2018-05-14 14:25:00 | 32 | < 0.1% |
| 2018-05-04 15:46:00 | 29 | < 0.1% |
| 2017-04-24 11:31:17 | 29 | < 0.1% |
| 2018-08-08 15:01:00 | 27 | < 0.1% |
| 2017-06-16 15:50:28 | 26 | < 0.1% |
| 2017-03-15 11:16:33 | 24 | < 0.1% |
| Other values (78857) | 113501 | |
| (Missing) | 1185 | 1.0% |
Length
| Value | Count | Frequency (%) |
| 2017-11-28 | 908 | 0.4% |
| 2017-11-27 | 789 | 0.3% |
| 2017-11-29 | 691 | 0.3% |
| 2018-02-27 | 611 | 0.3% |
| 2018-03-27 | 608 | 0.3% |
| 2018-08-06 | 588 | 0.3% |
| 2017-11-30 | 565 | 0.2% |
| 2018-05-14 | 562 | 0.2% |
| 2018-08-13 | 542 | 0.2% |
| 2018-05-03 | 532 | 0.2% |
| Other values (36934) | 221308 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 93239 |
|---|---|
| Distinct (%) | 82.8% |
| Missing | 2384 |
| Missing (%) | 2.1% |
| Memory size | 898.9 KiB |
| 2017-08-14 12:46:18 | 63 |
|---|---|
| 2017-10-18 22:35:50 | 38 |
| 2017-06-22 16:04:46 | 26 |
| 2017-03-21 13:32:45 | 24 |
| 2018-06-01 15:18:45 | 24 |
| Other values (93234) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 80365 ? |
|---|---|
| Unique (%) | 71.3% |
Sample
| 1st row | 2017-10-10 21:25:13 |
|---|---|
| 2nd row | 2017-10-10 21:25:13 |
| 3rd row | 2017-10-10 21:25:13 |
| 4th row | 2017-08-18 14:44:43 |
| 5th row | 2017-08-07 18:30:01 |
Common Values
| Value | Count | Frequency (%) |
| 2017-08-14 12:46:18 | 63 | 0.1% |
| 2017-10-18 22:35:50 | 38 | < 0.1% |
| 2017-06-22 16:04:46 | 26 | < 0.1% |
| 2017-03-21 13:32:45 | 24 | < 0.1% |
| 2018-06-01 15:18:45 | 24 | < 0.1% |
| 2018-02-28 20:09:19 | 24 | < 0.1% |
| 2017-11-30 14:59:18 | 24 | < 0.1% |
| 2017-07-27 20:52:15 | 24 | < 0.1% |
| 2017-10-22 14:43:54 | 22 | < 0.1% |
| 2017-12-21 16:33:10 | 22 | < 0.1% |
| Other values (93229) | 112362 | |
| (Missing) | 2384 | 2.1% |
Length
| Value | Count | Frequency (%) |
| 2018-05-21 | 520 | 0.2% |
| 2018-05-14 | 518 | 0.2% |
| 2018-08-13 | 502 | 0.2% |
| 2018-05-18 | 497 | 0.2% |
| 2018-08-27 | 496 | 0.2% |
| 2018-05-03 | 488 | 0.2% |
| 2018-04-11 | 481 | 0.2% |
| 2018-08-23 | 477 | 0.2% |
| 2017-12-11 | 477 | 0.2% |
| 2018-04-30 | 475 | 0.2% |
| Other values (41214) | 220375 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 449 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| 2017-12-20 00:00:00 | 644 |
|---|---|
| 2018-03-12 00:00:00 | 602 |
| 2018-05-29 00:00:00 | 596 |
| 2018-03-13 00:00:00 | 593 |
| 2018-07-16 00:00:00 | 586 |
| Other values (444) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 19 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2017-10-18 00:00:00 |
|---|---|
| 2nd row | 2017-10-18 00:00:00 |
| 3rd row | 2017-10-18 00:00:00 |
| 4th row | 2017-08-28 00:00:00 |
| 5th row | 2017-08-15 00:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2017-12-20 00:00:00 | 644 | 0.6% |
| 2018-03-12 00:00:00 | 602 | 0.5% |
| 2018-05-29 00:00:00 | 596 | 0.5% |
| 2018-03-13 00:00:00 | 593 | 0.5% |
| 2018-07-16 00:00:00 | 586 | 0.5% |
| 2018-07-05 00:00:00 | 582 | 0.5% |
| 2018-05-28 00:00:00 | 576 | 0.5% |
| 2018-05-30 00:00:00 | 575 | 0.5% |
| 2018-02-14 00:00:00 | 570 | 0.5% |
| 2017-12-19 00:00:00 | 564 | 0.5% |
| Other values (439) | 109149 |
Length
| Value | Count | Frequency (%) |
| 00:00:00 | 115037 | |
| 2017-12-20 | 644 | 0.3% |
| 2018-03-12 | 602 | 0.3% |
| 2018-05-29 | 596 | 0.3% |
| 2018-03-13 | 593 | 0.3% |
| 2018-07-16 | 586 | 0.3% |
| 2018-07-05 | 582 | 0.3% |
| 2018-05-28 | 576 | 0.3% |
| 2018-05-30 | 575 | 0.2% |
| 2018-02-14 | 570 | 0.2% |
| Other values (440) | 109713 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
order_item_id
Real number (ℝ≥0)
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.194685188 |
| Minimum | 1 |
|---|---|
| Maximum | 21 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 898.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 21 |
| Range | 20 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.6866861517 |
|---|---|
| Coefficient of variation (CV) | 0.5747841846 |
| Kurtosis | 93.45279755 |
| Mean | 1.194685188 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.198477309 |
| Sum | 137433 |
| Variance | 0.471537871 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 100838 | |
| 2 | 10000 | 8.7% |
| 3 | 2318 | 2.0% |
| 4 | 964 | 0.8% |
| 5 | 456 | 0.4% |
| 6 | 256 | 0.2% |
| 7 | 60 | 0.1% |
| 8 | 35 | < 0.1% |
| 9 | 28 | < 0.1% |
| 10 | 25 | < 0.1% |
| Other values (11) | 57 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 100838 | |
| 2 | 10000 | 8.7% |
| 3 | 2318 | 2.0% |
| 4 | 964 | 0.8% |
| 5 | 456 | 0.4% |
| 6 | 256 | 0.2% |
| 7 | 60 | 0.1% |
| 8 | 35 | < 0.1% |
| 9 | 28 | < 0.1% |
| 10 | 25 | < 0.1% |
| Value | Count | Frequency (%) |
| 21 | 1 | < 0.1% |
| 20 | 2 | < 0.1% |
| 19 | 2 | < 0.1% |
| 18 | 2 | < 0.1% |
| 17 | 2 | < 0.1% |
| 16 | 2 | < 0.1% |
| 15 | 4 | < 0.1% |
| 14 | 6 | |
| 13 | 7 | |
| 12 | 12 |
| Distinct | 32063 |
|---|---|
| Distinct (%) | 27.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| aca2eb7d00ea1a7b8ebd4e68314663af | 531 |
|---|---|
| 99a4788cb24856965c36a24e339b6058 | 516 |
| 422879e10f46682990de24d770e7f83d | 506 |
| 389d119b48cf3043d311335e499d9c6b | 404 |
| 368c6c730842d78016ad823897a372db | 392 |
| Other values (32058) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 16892 ? |
|---|---|
| Unique (%) | 14.7% |
Sample
| 1st row | 87285b34884572647811a353c7ac498a |
|---|---|
| 2nd row | 87285b34884572647811a353c7ac498a |
| 3rd row | 87285b34884572647811a353c7ac498a |
| 4th row | 87285b34884572647811a353c7ac498a |
| 5th row | 87285b34884572647811a353c7ac498a |
Common Values
| Value | Count | Frequency (%) |
| aca2eb7d00ea1a7b8ebd4e68314663af | 531 | 0.5% |
| 99a4788cb24856965c36a24e339b6058 | 516 | 0.4% |
| 422879e10f46682990de24d770e7f83d | 506 | 0.4% |
| 389d119b48cf3043d311335e499d9c6b | 404 | 0.4% |
| 368c6c730842d78016ad823897a372db | 392 | 0.3% |
| 53759a2ecddad2bb87a079a1f1519f73 | 389 | 0.3% |
| d1c427060a0f73f6b889a5c7c61f2ac4 | 353 | 0.3% |
| 53b36df67ebb7c41585e8d54d6772e08 | 323 | 0.3% |
| 154e7e31ebfa092203795c972e5804a6 | 291 | 0.3% |
| 3dd2a17168ec895c781a9191c1e95ad7 | 276 | 0.2% |
| Other values (32053) | 111056 |
Length
| Value | Count | Frequency (%) |
| aca2eb7d00ea1a7b8ebd4e68314663af | 531 | 0.5% |
| 99a4788cb24856965c36a24e339b6058 | 516 | 0.4% |
| 422879e10f46682990de24d770e7f83d | 506 | 0.4% |
| 389d119b48cf3043d311335e499d9c6b | 404 | 0.4% |
| 368c6c730842d78016ad823897a372db | 392 | 0.3% |
| 53759a2ecddad2bb87a079a1f1519f73 | 389 | 0.3% |
| d1c427060a0f73f6b889a5c7c61f2ac4 | 353 | 0.3% |
| 53b36df67ebb7c41585e8d54d6772e08 | 323 | 0.3% |
| 154e7e31ebfa092203795c972e5804a6 | 291 | 0.3% |
| 3dd2a17168ec895c781a9191c1e95ad7 | 276 | 0.2% |
| Other values (32053) | 111056 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 3021 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| 4a3ca9315b744ce9f8e9374361493884 | 2126 |
|---|---|
| 6560211a19b47992c3666cc44a7e94c0 | 2105 |
| 1f50f920176fa81dab994f9023523100 | 2004 |
| cc419e0650a3c5ba77189a1882b7556a | 1871 |
| da8622b14eb17ae2831f4ac5b9dab84a | 1654 |
| Other values (3016) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 488 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
|---|---|
| 2nd row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
| 3rd row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
| 4th row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
| 5th row | 3504c0cb71d7fa48d967e0e4c94d59d9 |
Common Values
| Value | Count | Frequency (%) |
| 4a3ca9315b744ce9f8e9374361493884 | 2126 | 1.8% |
| 6560211a19b47992c3666cc44a7e94c0 | 2105 | 1.8% |
| 1f50f920176fa81dab994f9023523100 | 2004 | 1.7% |
| cc419e0650a3c5ba77189a1882b7556a | 1871 | 1.6% |
| da8622b14eb17ae2831f4ac5b9dab84a | 1654 | 1.4% |
| 955fee9216a65b617aa5c0531780ce60 | 1513 | 1.3% |
| 1025f0e2d44d7041d6cf58b6550e0bfa | 1460 | 1.3% |
| 7c67e1448b00f6e969d365cea6b010ab | 1451 | 1.3% |
| 7a67c85e85bb2ce8582c35f2203ad736 | 1233 | 1.1% |
| ea8482cd71df3c1969d7b9473ff13abc | 1229 | 1.1% |
| Other values (3011) | 98391 |
Length
| Value | Count | Frequency (%) |
| 4a3ca9315b744ce9f8e9374361493884 | 2126 | 1.8% |
| 6560211a19b47992c3666cc44a7e94c0 | 2105 | 1.8% |
| 1f50f920176fa81dab994f9023523100 | 2004 | 1.7% |
| cc419e0650a3c5ba77189a1882b7556a | 1871 | 1.6% |
| da8622b14eb17ae2831f4ac5b9dab84a | 1654 | 1.4% |
| 955fee9216a65b617aa5c0531780ce60 | 1513 | 1.3% |
| 1025f0e2d44d7041d6cf58b6550e0bfa | 1460 | 1.3% |
| 7c67e1448b00f6e969d365cea6b010ab | 1451 | 1.3% |
| 7a67c85e85bb2ce8582c35f2203ad736 | 1233 | 1.1% |
| ea8482cd71df3c1969d7b9473ff13abc | 1229 | 1.1% |
| Other values (3011) | 98391 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 90958 |
|---|---|
| Distinct (%) | 79.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| 2017-08-14 20:43:31 | 63 |
|---|---|
| 2017-10-05 17:44:41 | 38 |
| 2017-04-27 09:10:13 | 29 |
| 2017-06-15 16:15:08 | 26 |
| 2018-05-15 15:30:28 | 24 |
| Other values (90953) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 75119 ? |
|---|---|
| Unique (%) | 65.3% |
Sample
| 1st row | 2017-10-06 11:07:15 |
|---|---|
| 2nd row | 2017-10-06 11:07:15 |
| 3rd row | 2017-10-06 11:07:15 |
| 4th row | 2017-08-21 20:05:16 |
| 5th row | 2017-08-08 18:37:31 |
Common Values
| Value | Count | Frequency (%) |
| 2017-08-14 20:43:31 | 63 | 0.1% |
| 2017-10-05 17:44:41 | 38 | < 0.1% |
| 2017-04-27 09:10:13 | 29 | < 0.1% |
| 2017-06-15 16:15:08 | 26 | < 0.1% |
| 2018-05-15 15:30:28 | 24 | < 0.1% |
| 2018-02-27 12:28:15 | 24 | < 0.1% |
| 2017-07-13 15:10:17 | 24 | < 0.1% |
| 2017-03-15 23:39:26 | 24 | < 0.1% |
| 2017-11-30 14:16:34 | 24 | < 0.1% |
| 2017-10-24 13:06:21 | 22 | < 0.1% |
| Other values (90948) | 114739 |
Length
| Value | Count | Frequency (%) |
| 2017-11-30 | 1707 | 0.7% |
| 2017-12-07 | 773 | 0.3% |
| 2018-04-19 | 708 | 0.3% |
| 2018-08-07 | 671 | 0.3% |
| 2018-01-18 | 665 | 0.3% |
| 2018-05-10 | 664 | 0.3% |
| 2018-03-08 | 664 | 0.3% |
| 2018-03-22 | 655 | 0.3% |
| 2018-03-01 | 651 | 0.3% |
| 2018-02-22 | 644 | 0.3% |
| Other values (40089) | 222272 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 5860 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 120.6500148 |
| Minimum | 0.85 |
|---|---|
| Maximum | 6735 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 898.9 KiB |
Quantile statistics
| Minimum | 0.85 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 39.9 |
| median | 74.9 |
| Q3 | 134.9 |
| 95-th percentile | 349.9 |
| Maximum | 6735 |
| Range | 6734.15 |
| Interquartile range (IQR) | 95 |
Descriptive statistics
| Standard deviation | 182.8531136 |
|---|---|
| Coefficient of variation (CV) | 1.515566442 |
| Kurtosis | 107.9174333 |
| Mean | 120.6500148 |
| Median Absolute Deviation (MAD) | 42 |
| Skewness | 7.618326263 |
| Sum | 13879215.75 |
| Variance | 33435.26114 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59.9 | 2561 | 2.2% |
| 69.9 | 2089 | 1.8% |
| 49.9 | 2005 | 1.7% |
| 89.9 | 1598 | 1.4% |
| 99.9 | 1491 | 1.3% |
| 29.9 | 1355 | 1.2% |
| 39.9 | 1321 | 1.1% |
| 79.9 | 1263 | 1.1% |
| 19.9 | 1253 | 1.1% |
| 29.99 | 1202 | 1.0% |
| Other values (5850) | 98899 |
| Value | Count | Frequency (%) |
| 0.85 | 3 | < 0.1% |
| 1.2 | 20 | |
| 2.2 | 2 | < 0.1% |
| 2.29 | 1 | < 0.1% |
| 2.9 | 1 | < 0.1% |
| 2.99 | 1 | < 0.1% |
| 3.06 | 3 | < 0.1% |
| 3.49 | 3 | < 0.1% |
| 3.5 | 7 | < 0.1% |
| 3.54 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6735 | 1 | |
| 6499 | 1 | |
| 4799 | 1 | |
| 4690 | 1 | |
| 4590 | 1 | |
| 4399.87 | 1 | |
| 4099.99 | 1 | |
| 4059 | 1 | |
| 3999.9 | 1 | |
| 3999 | 2 |
| Distinct | 6944 |
|---|---|
| Distinct (%) | 6.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.04932535 |
| Minimum | 0 |
|---|---|
| Maximum | 409.68 |
| Zeros | 386 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 898.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 7.78 |
| Q1 | 13.08 |
| median | 16.32 |
| Q3 | 21.2 |
| 95-th percentile | 45.332 |
| Maximum | 409.68 |
| Range | 409.68 |
| Interquartile range (IQR) | 8.12 |
Descriptive statistics
| Standard deviation | 15.85042324 |
|---|---|
| Coefficient of variation (CV) | 0.7905714015 |
| Kurtosis | 58.28785167 |
| Mean | 20.04932535 |
| Median Absolute Deviation (MAD) | 3.63 |
| Skewness | 5.563999669 |
| Sum | 2306414.24 |
| Variance | 251.2359169 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15.1 | 3732 | 3.2% |
| 7.78 | 2281 | 2.0% |
| 11.85 | 1948 | 1.7% |
| 14.1 | 1916 | 1.7% |
| 18.23 | 1592 | 1.4% |
| 7.39 | 1554 | 1.4% |
| 16.11 | 1181 | 1.0% |
| 15.23 | 1033 | 0.9% |
| 8.72 | 948 | 0.8% |
| 16.79 | 901 | 0.8% |
| Other values (6934) | 97951 |
| Value | Count | Frequency (%) |
| 0 | 386 | |
| 0.01 | 4 | < 0.1% |
| 0.02 | 3 | < 0.1% |
| 0.03 | 14 | < 0.1% |
| 0.04 | 4 | < 0.1% |
| 0.05 | 3 | < 0.1% |
| 0.06 | 13 | < 0.1% |
| 0.07 | 1 | < 0.1% |
| 0.08 | 12 | < 0.1% |
| 0.09 | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 409.68 | 1 | |
| 375.28 | 2 | |
| 339.59 | 1 | |
| 338.3 | 1 | |
| 322.1 | 1 | |
| 321.88 | 1 | |
| 321.46 | 1 | |
| 317.47 | 1 | |
| 314.4 | 1 | |
| 314.02 | 1 |
| Distinct | 2203 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24523.88605 |
| Minimum | 1001 |
|---|---|
| Maximum | 99730 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 898.9 KiB |
Quantile statistics
| Minimum | 1001 |
|---|---|
| 5-th percentile | 2972 |
| Q1 | 6429 |
| median | 13720 |
| Q3 | 28470 |
| 95-th percentile | 88330 |
| Maximum | 99730 |
| Range | 98729 |
| Interquartile range (IQR) | 22041 |
Descriptive statistics
| Standard deviation | 27644.64337 |
|---|---|
| Coefficient of variation (CV) | 1.127253785 |
| Kurtosis | 0.9073104887 |
| Mean | 24523.88605 |
| Median Absolute Deviation (MAD) | 8120 |
| Skewness | 1.548919582 |
| Sum | 2821154280 |
| Variance | 764226306.9 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 14940 | 8200 | 7.1% |
| 5849 | 2119 | 1.8% |
| 15025 | 2085 | 1.8% |
| 9015 | 1877 | 1.6% |
| 13405 | 1665 | 1.4% |
| 8577 | 1542 | 1.3% |
| 4782 | 1532 | 1.3% |
| 3204 | 1460 | 1.3% |
| 4160 | 1257 | 1.1% |
| 13232 | 1241 | 1.1% |
| Other values (2193) | 92059 |
| Value | Count | Frequency (%) |
| 1001 | 22 | < 0.1% |
| 1021 | 40 | < 0.1% |
| 1022 | 5 | < 0.1% |
| 1023 | 5 | < 0.1% |
| 1026 | 301 | |
| 1031 | 122 | |
| 1035 | 17 | < 0.1% |
| 1039 | 1 | < 0.1% |
| 1040 | 21 | < 0.1% |
| 1041 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 99730 | 12 | < 0.1% |
| 99700 | 2 | < 0.1% |
| 99670 | 1 | < 0.1% |
| 99500 | 61 | |
| 99300 | 2 | < 0.1% |
| 98975 | 19 | < 0.1% |
| 98920 | 1 | < 0.1% |
| 98910 | 13 | < 0.1% |
| 98803 | 65 | |
| 98780 | 4 | < 0.1% |
| Distinct | 604 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| sao paulo | |
|---|---|
| ibitinga | |
| santo andre | 3117 |
| curitiba | 3101 |
| sao jose do rio preto | 2662 |
| Other values (599) |
Length
| Max length | 40 |
|---|---|
| Median length | 9 |
| Mean length | 10.10215844 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 68 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | maua |
|---|---|
| 2nd row | maua |
| 3rd row | maua |
| 4th row | maua |
| 5th row | maua |
Common Values
| Value | Count | Frequency (%) |
| sao paulo | 28595 | |
| ibitinga | 8200 | 7.1% |
| santo andre | 3117 | 2.7% |
| curitiba | 3101 | 2.7% |
| sao jose do rio preto | 2662 | 2.3% |
| belo horizonte | 2578 | 2.2% |
| rio de janeiro | 2446 | 2.1% |
| ribeirao preto | 2325 | 2.0% |
| maringa | 2274 | 2.0% |
| guarulhos | 2049 | 1.8% |
| Other values (594) | 57690 |
Length
| Value | Count | Frequency (%) |
| sao | 35553 | 18.0% |
| paulo | 28876 | 14.6% |
| ibitinga | 8200 | 4.1% |
| rio | 5791 | 2.9% |
| preto | 5415 | 2.7% |
| do | 5409 | 2.7% |
| jose | 4026 | 2.0% |
| de | 3908 | 2.0% |
| santo | 3235 | 1.6% |
| andre | 3132 | 1.6% |
| Other values (634) | 94193 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| SP | |
|---|---|
| PR | |
| MG | |
| RJ | 4891 |
| SC | 4217 |
| Other values (18) | 6023 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | SP |
|---|---|
| 2nd row | SP |
| 3rd row | SP |
| 4th row | SP |
| 5th row | SP |
Common Values
| Value | Count | Frequency (%) |
| SP | 82041 | |
| PR | 8943 | 7.8% |
| MG | 8922 | 7.8% |
| RJ | 4891 | 4.3% |
| SC | 4217 | 3.7% |
| RS | 2216 | 1.9% |
| DF | 893 | 0.8% |
| BA | 693 | 0.6% |
| GO | 535 | 0.5% |
| PE | 460 | 0.4% |
| Other values (13) | 1226 | 1.1% |
Length
| Value | Count | Frequency (%) |
| sp | 82041 | |
| pr | 8943 | 7.8% |
| mg | 8922 | 7.8% |
| rj | 4891 | 4.3% |
| sc | 4217 | 3.7% |
| rs | 2216 | 1.9% |
| df | 893 | 0.8% |
| ba | 693 | 0.6% |
| go | 535 | 0.5% |
| pe | 460 | 0.4% |
| Other values (13) | 1226 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 92939 |
|---|---|
| Distinct (%) | 80.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| 9a736b248f67d166d2fbb006bcb877c3 | 75 |
|---|---|
| 6fbc7cdadbb522125f4b27ae9dee4060 | 38 |
| f9ae226291893fda10af7965268fb7f6 | 35 |
| 8af7ac63b2efbcbd88e5b11505e8098a | 29 |
| 569aa12b73b5f7edeaa6f2a01603e381 | 26 |
| Other values (92934) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 78991 ? |
|---|---|
| Unique (%) | 68.7% |
Sample
| 1st row | 7c396fd4830fd04220f754e42b4e5bff |
|---|---|
| 2nd row | 7c396fd4830fd04220f754e42b4e5bff |
| 3rd row | 7c396fd4830fd04220f754e42b4e5bff |
| 4th row | 3a51803cc0d012c3b5dc8b7528cb05f7 |
| 5th row | ef0996a1a279c26e7ecbd737be23d235 |
Common Values
| Value | Count | Frequency (%) |
| 9a736b248f67d166d2fbb006bcb877c3 | 75 | 0.1% |
| 6fbc7cdadbb522125f4b27ae9dee4060 | 38 | < 0.1% |
| f9ae226291893fda10af7965268fb7f6 | 35 | < 0.1% |
| 8af7ac63b2efbcbd88e5b11505e8098a | 29 | < 0.1% |
| 569aa12b73b5f7edeaa6f2a01603e381 | 26 | < 0.1% |
| 85963fd37bfd387aa6d915d8a1065486 | 24 | < 0.1% |
| c8460e4251689ba205045f3ea17884a1 | 24 | < 0.1% |
| d97b3cfb22b0d6b25ac9ed4e9c2d481b | 24 | < 0.1% |
| 90807fdb59eec2152bc977feeb6e47e7 | 24 | < 0.1% |
| 1d2435aa3b858d45c707c9fc25e18779 | 24 | < 0.1% |
| Other values (92929) | 114714 |
Length
| Value | Count | Frequency (%) |
| 9a736b248f67d166d2fbb006bcb877c3 | 75 | 0.1% |
| 6fbc7cdadbb522125f4b27ae9dee4060 | 38 | < 0.1% |
| f9ae226291893fda10af7965268fb7f6 | 35 | < 0.1% |
| 8af7ac63b2efbcbd88e5b11505e8098a | 29 | < 0.1% |
| 569aa12b73b5f7edeaa6f2a01603e381 | 26 | < 0.1% |
| 85963fd37bfd387aa6d915d8a1065486 | 24 | < 0.1% |
| c8460e4251689ba205045f3ea17884a1 | 24 | < 0.1% |
| d97b3cfb22b0d6b25ac9ed4e9c2d481b | 24 | < 0.1% |
| 90807fdb59eec2152bc977feeb6e47e7 | 24 | < 0.1% |
| 1d2435aa3b858d45c707c9fc25e18779 | 24 | < 0.1% |
| Other values (92929) | 114714 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 14747 |
|---|---|
| Distinct (%) | 12.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 34983.3783 |
| Minimum | 1003 |
|---|---|
| Maximum | 99980 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 898.9 KiB |
Quantile statistics
| Minimum | 1003 |
|---|---|
| 5-th percentile | 3280 |
| Q1 | 11095 |
| median | 24230 |
| Q3 | 58297 |
| 95-th percentile | 90620 |
| Maximum | 99980 |
| Range | 98977 |
| Interquartile range (IQR) | 47202 |
Descriptive statistics
| Standard deviation | 29829.43897 |
|---|---|
| Coefficient of variation (CV) | 0.852674625 |
| Kurtosis | -0.7723390905 |
| Mean | 34983.3783 |
| Median Absolute Deviation (MAD) | 16199 |
| Skewness | 0.7907870136 |
| Sum | 4024382889 |
| Variance | 889795429.3 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24220 | 154 | 0.1% |
| 22793 | 151 | 0.1% |
| 22790 | 149 | 0.1% |
| 24230 | 138 | 0.1% |
| 22775 | 126 | 0.1% |
| 35162 | 123 | 0.1% |
| 29101 | 112 | 0.1% |
| 13087 | 107 | 0.1% |
| 11740 | 106 | 0.1% |
| 36570 | 104 | 0.1% |
| Other values (14737) | 113767 |
| Value | Count | Frequency (%) |
| 1003 | 1 | < 0.1% |
| 1004 | 2 | < 0.1% |
| 1005 | 6 | |
| 1006 | 2 | < 0.1% |
| 1007 | 4 | |
| 1008 | 3 | < 0.1% |
| 1009 | 8 | |
| 1011 | 6 | |
| 1012 | 2 | < 0.1% |
| 1013 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 99980 | 3 | < 0.1% |
| 99970 | 1 | < 0.1% |
| 99965 | 2 | < 0.1% |
| 99960 | 1 | < 0.1% |
| 99955 | 3 | < 0.1% |
| 99950 | 9 | |
| 99940 | 2 | < 0.1% |
| 99930 | 5 | |
| 99925 | 1 | < 0.1% |
| 99920 | 1 | < 0.1% |
| Distinct | 4044 |
|---|---|
| Distinct (%) | 3.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| sao paulo | |
|---|---|
| rio de janeiro | 7993 |
| belo horizonte | 3186 |
| brasilia | 2236 |
| curitiba | 1786 |
| Other values (4039) |
Length
| Max length | 32 |
|---|---|
| Median length | 9 |
| Mean length | 10.33729148 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1004 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | sao paulo |
|---|---|
| 2nd row | sao paulo |
| 3rd row | sao paulo |
| 4th row | sao paulo |
| 5th row | sao paulo |
Common Values
| Value | Count | Frequency (%) |
| sao paulo | 18224 | 15.8% |
| rio de janeiro | 7993 | 6.9% |
| belo horizonte | 3186 | 2.8% |
| brasilia | 2236 | 1.9% |
| curitiba | 1786 | 1.6% |
| campinas | 1698 | 1.5% |
| porto alegre | 1625 | 1.4% |
| salvador | 1459 | 1.3% |
| guarulhos | 1368 | 1.2% |
| sao bernardo do campo | 1094 | 1.0% |
| Other values (4034) | 74368 |
Length
| Value | Count | Frequency (%) |
| sao | 24557 | 12.2% |
| paulo | 18305 | 9.1% |
| de | 11227 | 5.6% |
| rio | 9596 | 4.8% |
| janeiro | 7993 | 4.0% |
| do | 4944 | 2.4% |
| belo | 3259 | 1.6% |
| horizonte | 3214 | 1.6% |
| brasilia | 2246 | 1.1% |
| porto | 1934 | 1.0% |
| Other values (3234) | 114544 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| SP | |
|---|---|
| RJ | |
| MG | |
| RS | |
| PR | |
| Other values (22) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SP |
|---|---|
| 2nd row | SP |
| 3rd row | SP |
| 4th row | SP |
| 5th row | SP |
Common Values
| Value | Count | Frequency (%) |
| SP | 48683 | |
| RJ | 14929 | 13.0% |
| MG | 13386 | 11.6% |
| RS | 6392 | 5.6% |
| PR | 5854 | 5.1% |
| SC | 4209 | 3.7% |
| BA | 3920 | 3.4% |
| GO | 2346 | 2.0% |
| ES | 2285 | 2.0% |
| DF | 2251 | 2.0% |
| Other values (17) | 10782 | 9.4% |
Length
| Value | Count | Frequency (%) |
| sp | 48683 | |
| rj | 14929 | 13.0% |
| mg | 13386 | 11.6% |
| rs | 6392 | 5.6% |
| pr | 5854 | 5.1% |
| sc | 4209 | 3.7% |
| ba | 3920 | 3.4% |
| go | 2346 | 2.0% |
| es | 2285 | 2.0% |
| df | 2251 | 2.0% |
| Other values (17) | 10782 | 9.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 71 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| cama_mesa_banho | |
|---|---|
| beleza_saude | |
| esporte_lazer | |
| moveis_decoracao | |
| informatica_acessorios | |
| Other values (66) |
Length
| Max length | 46 |
|---|---|
| Median length | 15 |
| Mean length | 14.88322887 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | utilidades_domesticas |
|---|---|
| 2nd row | utilidades_domesticas |
| 3rd row | utilidades_domesticas |
| 4th row | utilidades_domesticas |
| 5th row | utilidades_domesticas |
Common Values
| Value | Count | Frequency (%) |
| cama_mesa_banho | 11819 | 10.3% |
| beleza_saude | 9914 | 8.6% |
| esporte_lazer | 8925 | 7.8% |
| moveis_decoracao | 8723 | 7.6% |
| informatica_acessorios | 8075 | 7.0% |
| utilidades_domesticas | 7312 | 6.4% |
| relogios_presentes | 6136 | 5.3% |
| telefonia | 4661 | 4.1% |
| ferramentas_jardim | 4547 | 4.0% |
| automotivo | 4346 | 3.8% |
| Other values (61) | 40579 |
Length
| Value | Count | Frequency (%) |
| cama_mesa_banho | 11819 | 10.3% |
| beleza_saude | 9914 | 8.6% |
| esporte_lazer | 8925 | 7.8% |
| moveis_decoracao | 8723 | 7.6% |
| informatica_acessorios | 8075 | 7.0% |
| utilidades_domesticas | 7312 | 6.4% |
| relogios_presentes | 6136 | 5.3% |
| telefonia | 4661 | 4.1% |
| ferramentas_jardim | 4547 | 4.0% |
| automotivo | 4346 | 3.8% |
| Other values (61) | 40579 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
product_name_lenght
Real number (ℝ≥0)
| Distinct | 66 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48.75428775 |
| Minimum | 5 |
|---|---|
| Maximum | 76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 898.9 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 42 |
| median | 52 |
| Q3 | 57 |
| 95-th percentile | 60 |
| Maximum | 76 |
| Range | 71 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 10.03833567 |
|---|---|
| Coefficient of variation (CV) | 0.2058964684 |
| Kurtosis | 0.1464021057 |
| Mean | 48.75428775 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.9041148344 |
| Sum | 5608547 |
| Variance | 100.768183 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 59 | 8570 | 7.4% |
| 60 | 7904 | 6.9% |
| 56 | 6775 | 5.9% |
| 58 | 6712 | 5.8% |
| 57 | 6219 | 5.4% |
| 55 | 5773 | 5.0% |
| 54 | 5443 | 4.7% |
| 53 | 4306 | 3.7% |
| 52 | 4242 | 3.7% |
| 49 | 3659 | 3.2% |
| Other values (56) | 55434 |
| Value | Count | Frequency (%) |
| 5 | 9 | < 0.1% |
| 6 | 3 | < 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 4 | < 0.1% |
| 9 | 14 | < 0.1% |
| 10 | 8 | < 0.1% |
| 11 | 11 | < 0.1% |
| 12 | 37 | |
| 13 | 26 | |
| 14 | 46 |
| Value | Count | Frequency (%) |
| 76 | 1 | < 0.1% |
| 72 | 9 | < 0.1% |
| 69 | 1 | < 0.1% |
| 68 | 1 | < 0.1% |
| 67 | 3 | < 0.1% |
| 66 | 1 | < 0.1% |
| 64 | 169 | 0.1% |
| 63 | 1332 | |
| 62 | 160 | 0.1% |
| 61 | 238 | 0.2% |
| Distinct | 2958 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 785.867573 |
| Minimum | 4 |
|---|---|
| Maximum | 3992 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 898.9 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 159.8 |
| Q1 | 345 |
| median | 600 |
| Q3 | 982 |
| 95-th percentile | 2125.2 |
| Maximum | 3992 |
| Range | 3988 |
| Interquartile range (IQR) | 637 |
Descriptive statistics
| Standard deviation | 653.0514924 |
|---|---|
| Coefficient of variation (CV) | 0.8309943238 |
| Kurtosis | 4.91709565 |
| Mean | 785.867573 |
| Median Absolute Deviation (MAD) | 296 |
| Skewness | 2.011066015 |
| Sum | 90403848 |
| Variance | 426476.2518 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 341 | 706 | 0.6% |
| 1893 | 663 | 0.6% |
| 348 | 642 | 0.6% |
| 492 | 588 | 0.5% |
| 903 | 586 | 0.5% |
| 245 | 575 | 0.5% |
| 366 | 529 | 0.5% |
| 236 | 510 | 0.4% |
| 340 | 483 | 0.4% |
| 919 | 436 | 0.4% |
| Other values (2948) | 109319 |
| Value | Count | Frequency (%) |
| 4 | 6 | |
| 8 | 2 | < 0.1% |
| 15 | 1 | < 0.1% |
| 20 | 7 | |
| 23 | 1 | < 0.1% |
| 26 | 2 | < 0.1% |
| 27 | 4 | |
| 28 | 2 | < 0.1% |
| 30 | 8 | |
| 31 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 3992 | 2 | < 0.1% |
| 3988 | 1 | < 0.1% |
| 3985 | 3 | |
| 3976 | 6 | |
| 3963 | 1 | < 0.1% |
| 3956 | 3 | |
| 3954 | 2 | < 0.1% |
| 3950 | 2 | < 0.1% |
| 3949 | 1 | < 0.1% |
| 3948 | 1 | < 0.1% |
product_photos_qty
Real number (ℝ≥0)
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.200318159 |
| Minimum | 1 |
|---|---|
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 898.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 6 |
| Maximum | 20 |
| Range | 19 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.713212606 |
|---|---|
| Coefficient of variation (CV) | 0.7786204006 |
| Kurtosis | 4.907432821 |
| Mean | 2.200318159 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.919275288 |
| Sum | 253118 |
| Variance | 2.935097433 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 58264 | |
| 2 | 22763 | 19.8% |
| 3 | 12791 | 11.1% |
| 4 | 8720 | 7.6% |
| 5 | 5540 | 4.8% |
| 6 | 3872 | 3.4% |
| 7 | 1463 | 1.3% |
| 8 | 766 | 0.7% |
| 10 | 351 | 0.3% |
| 9 | 309 | 0.3% |
| Other values (9) | 198 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 58264 | |
| 2 | 22763 | 19.8% |
| 3 | 12791 | 11.1% |
| 4 | 8720 | 7.6% |
| 5 | 5540 | 4.8% |
| 6 | 3872 | 3.4% |
| 7 | 1463 | 1.3% |
| 8 | 766 | 0.7% |
| 9 | 309 | 0.3% |
| 10 | 351 | 0.3% |
| Value | Count | Frequency (%) |
| 20 | 1 | < 0.1% |
| 19 | 2 | < 0.1% |
| 18 | 4 | < 0.1% |
| 17 | 11 | < 0.1% |
| 15 | 12 | < 0.1% |
| 14 | 6 | < 0.1% |
| 13 | 30 | < 0.1% |
| 12 | 60 | 0.1% |
| 11 | 72 | 0.1% |
| 10 | 351 |
| Distinct | 2197 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2112.365746 |
| Minimum | 0 |
|---|---|
| Maximum | 40425 |
| Zeros | 8 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 898.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 125 |
| Q1 | 300 |
| median | 700 |
| Q3 | 1800 |
| 95-th percentile | 9850 |
| Maximum | 40425 |
| Range | 40425 |
| Interquartile range (IQR) | 1500 |
Descriptive statistics
| Standard deviation | 3776.693083 |
|---|---|
| Coefficient of variation (CV) | 1.787897332 |
| Kurtosis | 15.932725 |
| Mean | 2112.365746 |
| Median Absolute Deviation (MAD) | 500 |
| Skewness | 3.570368112 |
| Sum | 242998106 |
| Variance | 14263410.64 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 200 | 6788 | 5.9% |
| 150 | 5295 | 4.6% |
| 250 | 4657 | 4.0% |
| 300 | 4295 | 3.7% |
| 100 | 3559 | 3.1% |
| 400 | 3460 | 3.0% |
| 350 | 3204 | 2.8% |
| 500 | 2775 | 2.4% |
| 600 | 2763 | 2.4% |
| 700 | 2083 | 1.8% |
| Other values (2187) | 76157 |
| Value | Count | Frequency (%) |
| 0 | 8 | < 0.1% |
| 2 | 5 | < 0.1% |
| 25 | 3 | < 0.1% |
| 50 | 982 | |
| 53 | 2 | < 0.1% |
| 54 | 2 | < 0.1% |
| 55 | 2 | < 0.1% |
| 58 | 1 | < 0.1% |
| 60 | 9 | < 0.1% |
| 61 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 40425 | 3 | < 0.1% |
| 30000 | 285 | |
| 29800 | 1 | < 0.1% |
| 29750 | 1 | < 0.1% |
| 29700 | 4 | < 0.1% |
| 29600 | 5 | < 0.1% |
| 29500 | 2 | < 0.1% |
| 29250 | 1 | < 0.1% |
| 29150 | 1 | < 0.1% |
| 29100 | 1 | < 0.1% |
| Distinct | 99 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.30089711 |
| Minimum | 7 |
|---|---|
| Maximum | 105 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 898.9 KiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 16 |
| Q1 | 18 |
| median | 25 |
| Q3 | 38 |
| 95-th percentile | 62 |
| Maximum | 105 |
| Range | 98 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 16.20368427 |
|---|---|
| Coefficient of variation (CV) | 0.5347592256 |
| Kurtosis | 3.668261707 |
| Mean | 30.30089711 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 1.74206068 |
| Sum | 3485694 |
| Variance | 262.5593841 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 16 | 17652 | 15.3% |
| 20 | 10556 | 9.2% |
| 30 | 7746 | 6.7% |
| 17 | 6103 | 5.3% |
| 18 | 5826 | 5.1% |
| 19 | 4832 | 4.2% |
| 25 | 4750 | 4.1% |
| 40 | 4230 | 3.7% |
| 22 | 3911 | 3.4% |
| 50 | 3081 | 2.7% |
| Other values (89) | 46349 |
| Value | Count | Frequency (%) |
| 7 | 32 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 4 | < 0.1% |
| 10 | 8 | < 0.1% |
| 11 | 96 | 0.1% |
| 12 | 40 | < 0.1% |
| 13 | 60 | 0.1% |
| 14 | 136 | 0.1% |
| 15 | 212 | 0.2% |
| 16 | 17652 |
| Value | Count | Frequency (%) |
| 105 | 329 | |
| 104 | 30 | < 0.1% |
| 103 | 45 | < 0.1% |
| 102 | 60 | 0.1% |
| 101 | 107 | 0.1% |
| 100 | 423 | |
| 99 | 36 | < 0.1% |
| 98 | 49 | < 0.1% |
| 97 | 11 | < 0.1% |
| 96 | 8 | < 0.1% |
| Distinct | 102 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.65871553 |
| Minimum | 2 |
|---|---|
| Maximum | 105 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 898.9 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 8 |
| median | 13 |
| Q3 | 20 |
| 95-th percentile | 45 |
| Maximum | 105 |
| Range | 103 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 13.48410769 |
|---|---|
| Coefficient of variation (CV) | 0.809432616 |
| Kurtosis | 7.274135572 |
| Mean | 16.65871553 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 2.240967679 |
| Sum | 1916352 |
| Variance | 181.8211603 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 10097 | 8.8% |
| 20 | 6775 | 5.9% |
| 15 | 6763 | 5.9% |
| 11 | 6250 | 5.4% |
| 12 | 6172 | 5.4% |
| 2 | 5039 | 4.4% |
| 4 | 4757 | 4.1% |
| 8 | 4747 | 4.1% |
| 16 | 4650 | 4.0% |
| 5 | 4613 | 4.0% |
| Other values (92) | 55173 |
| Value | Count | Frequency (%) |
| 2 | 5039 | |
| 3 | 2761 | 2.4% |
| 4 | 4757 | |
| 5 | 4613 | |
| 6 | 3490 | 3.0% |
| 7 | 4185 | |
| 8 | 4747 | |
| 9 | 3360 | 2.9% |
| 10 | 10097 | |
| 11 | 6250 |
| Value | Count | Frequency (%) |
| 105 | 137 | |
| 104 | 14 | < 0.1% |
| 103 | 49 | < 0.1% |
| 102 | 10 | < 0.1% |
| 100 | 42 | < 0.1% |
| 99 | 5 | < 0.1% |
| 98 | 3 | < 0.1% |
| 97 | 2 | < 0.1% |
| 96 | 8 | < 0.1% |
| 95 | 22 | < 0.1% |
| Distinct | 95 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.10408915 |
| Minimum | 6 |
|---|---|
| Maximum | 118 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 898.9 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 15 |
| median | 20 |
| Q3 | 30 |
| 95-th percentile | 45 |
| Maximum | 118 |
| Range | 112 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 11.73032474 |
|---|---|
| Coefficient of variation (CV) | 0.5077163898 |
| Kurtosis | 4.532601408 |
| Mean | 23.10408915 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 1.699763004 |
| Sum | 2657802 |
| Variance | 137.6005184 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20 | 12401 | 10.8% |
| 11 | 10622 | 9.2% |
| 15 | 8935 | 7.8% |
| 16 | 8653 | 7.5% |
| 30 | 7819 | 6.8% |
| 12 | 5568 | 4.8% |
| 13 | 5384 | 4.7% |
| 14 | 4723 | 4.1% |
| 18 | 4034 | 3.5% |
| 40 | 4034 | 3.5% |
| Other values (85) | 42863 |
| Value | Count | Frequency (%) |
| 6 | 2 | < 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 29 | < 0.1% |
| 9 | 51 | < 0.1% |
| 10 | 83 | 0.1% |
| 11 | 10622 | |
| 12 | 5568 | |
| 13 | 5384 | |
| 14 | 4723 | |
| 15 | 8935 |
| Value | Count | Frequency (%) |
| 118 | 7 | < 0.1% |
| 105 | 14 | < 0.1% |
| 104 | 1 | < 0.1% |
| 103 | 1 | < 0.1% |
| 102 | 2 | < 0.1% |
| 101 | 2 | < 0.1% |
| 100 | 43 | |
| 98 | 1 | < 0.1% |
| 97 | 1 | < 0.1% |
| 95 | 2 | < 0.1% |
payment_sequential
Real number (ℝ≥0)
| Distinct | 29 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.094056695 |
| Minimum | 1 |
|---|---|
| Maximum | 29 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 898.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 29 |
| Range | 28 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.7315441733 |
|---|---|
| Coefficient of variation (CV) | 0.6686528923 |
| Kurtosis | 348.8888491 |
| Mean | 1.094056695 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 15.96822497 |
| Sum | 125857 |
| Variance | 0.5351568775 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 110108 | |
| 2 | 3280 | 2.9% |
| 3 | 636 | 0.6% |
| 4 | 307 | 0.3% |
| 5 | 183 | 0.2% |
| 6 | 127 | 0.1% |
| 7 | 88 | 0.1% |
| 8 | 58 | 0.1% |
| 9 | 47 | < 0.1% |
| 10 | 40 | < 0.1% |
| Other values (19) | 163 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 110108 | |
| 2 | 3280 | 2.9% |
| 3 | 636 | 0.6% |
| 4 | 307 | 0.3% |
| 5 | 183 | 0.2% |
| 6 | 127 | 0.1% |
| 7 | 88 | 0.1% |
| 8 | 58 | 0.1% |
| 9 | 47 | < 0.1% |
| 10 | 40 | < 0.1% |
| Value | Count | Frequency (%) |
| 29 | 1 | < 0.1% |
| 28 | 1 | < 0.1% |
| 27 | 1 | < 0.1% |
| 26 | 2 | < 0.1% |
| 25 | 2 | < 0.1% |
| 24 | 2 | < 0.1% |
| 23 | 2 | < 0.1% |
| 22 | 3 | |
| 21 | 6 | |
| 20 | 6 |
payment_type
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| credit_card | |
|---|---|
| boleto | |
| voucher | 6142 |
| debit_card | 1655 |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 9.79818667 |
| Min length | 6 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | credit_card |
|---|---|
| 2nd row | voucher |
| 3rd row | voucher |
| 4th row | credit_card |
| 5th row | credit_card |
Common Values
| Value | Count | Frequency (%) |
| credit_card | 84834 | |
| boleto | 22406 | 19.5% |
| voucher | 6142 | 5.3% |
| debit_card | 1655 | 1.4% |
Length
Pie chart
| Value | Count | Frequency (%) |
| credit_card | 84834 | |
| boleto | 22406 | 19.5% |
| voucher | 6142 | 5.3% |
| debit_card | 1655 | 1.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
payment_installments
Real number (ℝ≥0)
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.944565661 |
| Minimum | 0 |
|---|---|
| Maximum | 24 |
| Zeros | 3 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 898.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 10 |
| Maximum | 24 |
| Range | 24 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.780108304 |
|---|---|
| Coefficient of variation (CV) | 0.9441488572 |
| Kurtosis | 2.529947266 |
| Mean | 2.944565661 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.620915505 |
| Sum | 338734 |
| Variance | 7.729002184 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 57328 | |
| 2 | 13352 | 11.6% |
| 3 | 11498 | 10.0% |
| 4 | 7820 | 6.8% |
| 10 | 6740 | 5.9% |
| 5 | 5888 | 5.1% |
| 8 | 4978 | 4.3% |
| 6 | 4519 | 3.9% |
| 7 | 1779 | 1.5% |
| 9 | 708 | 0.6% |
| Other values (14) | 427 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 3 | < 0.1% |
| 1 | 57328 | |
| 2 | 13352 | 11.6% |
| 3 | 11498 | 10.0% |
| 4 | 7820 | 6.8% |
| 5 | 5888 | 5.1% |
| 6 | 4519 | 3.9% |
| 7 | 1779 | 1.5% |
| 8 | 4978 | 4.3% |
| 9 | 708 | 0.6% |
| Value | Count | Frequency (%) |
| 24 | 34 | < 0.1% |
| 23 | 1 | < 0.1% |
| 22 | 1 | < 0.1% |
| 21 | 6 | < 0.1% |
| 20 | 20 | < 0.1% |
| 18 | 38 | |
| 17 | 7 | < 0.1% |
| 16 | 7 | < 0.1% |
| 15 | 91 | |
| 14 | 16 | < 0.1% |
| Distinct | 28598 |
|---|---|
| Distinct (%) | 24.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 172.4092939 |
| Minimum | 0 |
|---|---|
| Maximum | 13664.08 |
| Zeros | 6 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 898.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 27.19 |
| Q1 | 60.85 |
| median | 108 |
| Q3 | 189.43 |
| 95-th percentile | 515.1 |
| Maximum | 13664.08 |
| Range | 13664.08 |
| Interquartile range (IQR) | 128.58 |
Descriptive statistics
| Standard deviation | 266.2045083 |
|---|---|
| Coefficient of variation (CV) | 1.54402644 |
| Kurtosis | 524.9065678 |
| Mean | 172.4092939 |
| Median Absolute Deviation (MAD) | 56.75 |
| Skewness | 14.31714272 |
| Sum | 19833447.94 |
| Variance | 70864.84021 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50 | 337 | 0.3% |
| 20 | 283 | 0.2% |
| 100 | 282 | 0.2% |
| 77.57 | 247 | 0.2% |
| 35 | 162 | 0.1% |
| 73.34 | 157 | 0.1% |
| 30 | 133 | 0.1% |
| 116.94 | 130 | 0.1% |
| 56.78 | 120 | 0.1% |
| 155.14 | 119 | 0.1% |
| Other values (28588) | 113067 |
| Value | Count | Frequency (%) |
| 0 | 6 | |
| 0.01 | 6 | |
| 0.03 | 2 | < 0.1% |
| 0.05 | 2 | < 0.1% |
| 0.08 | 2 | < 0.1% |
| 0.09 | 1 | < 0.1% |
| 0.1 | 3 | |
| 0.11 | 2 | < 0.1% |
| 0.13 | 1 | < 0.1% |
| 0.14 | 4 |
| Value | Count | Frequency (%) |
| 13664.08 | 8 | |
| 7274.88 | 4 | |
| 6929.31 | 1 | < 0.1% |
| 6726.66 | 1 | < 0.1% |
| 6081.54 | 6 | |
| 4950.34 | 1 | < 0.1% |
| 4809.44 | 2 | < 0.1% |
| 4764.34 | 1 | < 0.1% |
| 4681.78 | 1 | < 0.1% |
| 4513.32 | 1 | < 0.1% |
| Distinct | 71 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| bed_bath_table | |
|---|---|
| health_beauty | |
| sports_leisure | |
| furniture_decor | |
| computers_accessories | |
| Other values (66) |
Length
| Max length | 39 |
|---|---|
| Median length | 13 |
| Mean length | 12.99040309 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | housewares |
|---|---|
| 2nd row | housewares |
| 3rd row | housewares |
| 4th row | housewares |
| 5th row | housewares |
Common Values
| Value | Count | Frequency (%) |
| bed_bath_table | 11819 | 10.3% |
| health_beauty | 9914 | 8.6% |
| sports_leisure | 8925 | 7.8% |
| furniture_decor | 8723 | 7.6% |
| computers_accessories | 8075 | 7.0% |
| housewares | 7312 | 6.4% |
| watches_gifts | 6136 | 5.3% |
| telephony | 4661 | 4.1% |
| garden_tools | 4547 | 4.0% |
| auto | 4346 | 3.8% |
| Other values (61) | 40579 |
Length
| Value | Count | Frequency (%) |
| bed_bath_table | 11819 | 10.3% |
| health_beauty | 9914 | 8.6% |
| sports_leisure | 8925 | 7.8% |
| furniture_decor | 8723 | 7.6% |
| computers_accessories | 8075 | 7.0% |
| housewares | 7312 | 6.4% |
| watches_gifts | 6136 | 5.3% |
| telephony | 4661 | 4.1% |
| garden_tools | 4547 | 4.0% |
| auto | 4346 | 3.8% |
| Other values (61) | 40579 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 14743 |
|---|---|
| Distinct (%) | 12.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -21.23576548 |
| Minimum | -36.60537441 |
|---|---|
| Maximum | 42.18400274 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 114914 |
| Negative (%) | 99.9% |
| Memory size | 898.9 KiB |
Quantile statistics
| Minimum | -36.60537441 |
|---|---|
| 5-th percentile | -28.62869711 |
| Q1 | -23.59002278 |
| median | -22.92991227 |
| Q3 | -20.19822232 |
| 95-th percentile | -7.97347196 |
| Maximum | 42.18400274 |
| Range | 78.78937715 |
| Interquartile range (IQR) | 3.391800461 |
Descriptive statistics
| Standard deviation | 5.571870904 |
|---|---|
| Coefficient of variation (CV) | -0.2623814483 |
| Kurtosis | 3.501648759 |
| Mean | -21.23576548 |
| Median Absolute Deviation (MAD) | 0.8913251649 |
| Skewness | 1.663469957 |
| Sum | -2442898.754 |
| Variance | 31.04574537 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -22.90581655 | 154 | 0.1% |
| -23.00927096 | 151 | 0.1% |
| -23.01133469 | 149 | 0.1% |
| -22.91127038 | 138 | 0.1% |
| -22.97295652 | 126 | 0.1% |
| -19.47809554 | 123 | 0.1% |
| -20.33161264 | 112 | 0.1% |
| -22.85275771 | 107 | 0.1% |
| -24.14965101 | 106 | 0.1% |
| -20.72193768 | 104 | 0.1% |
| Other values (14733) | 113767 |
| Value | Count | Frequency (%) |
| -36.60537441 | 12 | |
| -34.58642211 | 1 | < 0.1% |
| -33.69142292 | 5 | < 0.1% |
| -33.52560057 | 15 | |
| -32.5639516 | 9 | |
| -32.23127878 | 4 | < 0.1% |
| -32.20521717 | 1 | < 0.1% |
| -32.20428523 | 3 | < 0.1% |
| -32.18884625 | 4 | < 0.1% |
| -32.18810995 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 42.18400274 | 1 | < 0.1% |
| 41.14620291 | 2 | < 0.1% |
| 39.05762942 | 2 | < 0.1% |
| 3.844901491 | 1 | < 0.1% |
| 3.358232038 | 1 | < 0.1% |
| 2.859929195 | 4 | |
| 2.84462475 | 1 | < 0.1% |
| 2.833882311 | 3 | |
| 2.830159586 | 5 | |
| 2.824144071 | 1 | < 0.1% |
| Distinct | 14744 |
|---|---|
| Distinct (%) | 12.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -46.19785734 |
| Minimum | -72.66670555 |
|---|---|
| Maximum | -8.577855018 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 115037 |
| Negative (%) | 100.0% |
| Memory size | 898.9 KiB |
Quantile statistics
| Minimum | -72.66670555 |
|---|---|
| 5-th percentile | -52.38356841 |
| Q1 | -48.101695 |
| median | -46.632021 |
| Q3 | -43.62599281 |
| 95-th percentile | -38.5059849 |
| Maximum | -8.577855018 |
| Range | 64.08885053 |
| Interquartile range (IQR) | 4.475702196 |
Descriptive statistics
| Standard deviation | 4.05064469 |
|---|---|
| Coefficient of variation (CV) | -0.08768035843 |
| Kurtosis | 2.271704084 |
| Mean | -46.19785734 |
| Median Absolute Deviation (MAD) | 2.439993631 |
| Skewness | 0.02812258526 |
| Sum | -5314462.915 |
| Variance | 16.40772241 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -43.10698886 | 154 | 0.1% |
| -43.42940928 | 151 | 0.1% |
| -43.45025642 | 149 | 0.1% |
| -43.10515134 | 138 | 0.1% |
| -43.39706328 | 126 | 0.1% |
| -42.55679483 | 123 | 0.1% |
| -40.27958609 | 112 | 0.1% |
| -47.05510214 | 107 | 0.1% |
| -46.7480979 | 106 | 0.1% |
| -42.8660116 | 104 | 0.1% |
| Other values (14734) | 113767 |
| Value | Count | Frequency (%) |
| -72.66670555 | 3 | < 0.1% |
| -69.2590519 | 1 | < 0.1% |
| -68.7420032 | 3 | < 0.1% |
| -68.7409412 | 1 | < 0.1% |
| -68.50800699 | 2 | < 0.1% |
| -67.88426965 | 1 | < 0.1% |
| -67.85151077 | 8 | |
| -67.84345651 | 6 | |
| -67.83786946 | 9 | |
| -67.83511725 | 13 |
| Value | Count | Frequency (%) |
| -8.577855018 | 2 | < 0.1% |
| -8.723762148 | 1 | < 0.1% |
| -9.400036925 | 2 | < 0.1% |
| -34.80034036 | 1 | < 0.1% |
| -34.80818636 | 1 | < 0.1% |
| -34.82458363 | 7 | |
| -34.82467295 | 14 | |
| -34.82528062 | 6 | |
| -34.82560511 | 2 | < 0.1% |
| -34.82644069 | 7 |
| Distinct | 2203 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -22.79605947 |
| Minimum | -36.60537441 |
|---|---|
| Maximum | -2.546079234 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 115037 |
| Negative (%) | 100.0% |
| Memory size | 898.9 KiB |
Quantile statistics
| Minimum | -36.60537441 |
|---|---|
| 5-th percentile | -26.33054814 |
| Q1 | -23.61165419 |
| median | -23.42073909 |
| Q3 | -21.76647685 |
| 95-th percentile | -19.8498827 |
| Maximum | -2.546079234 |
| Range | 34.05929518 |
| Interquartile range (IQR) | 1.845177347 |
Descriptive statistics
| Standard deviation | 2.696611906 |
|---|---|
| Coefficient of variation (CV) | -0.1182928966 |
| Kurtosis | 18.18706634 |
| Mean | -22.79605947 |
| Median Absolute Deviation (MAD) | 0.5381883235 |
| Skewness | 2.764194626 |
| Sum | -2622390.294 |
| Variance | 7.271715773 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -21.76647685 | 8200 | 7.1% |
| -23.65111484 | 2119 | 1.8% |
| -20.80243626 | 2085 | 1.8% |
| -23.66570346 | 1877 | 1.6% |
| -22.71683929 | 1665 | 1.4% |
| -23.48262344 | 1542 | 1.3% |
| -23.693986 | 1532 | 1.3% |
| -23.59798552 | 1460 | 1.3% |
| -23.62358155 | 1257 | 1.1% |
| -23.20706431 | 1241 | 1.1% |
| Other values (2193) | 92059 |
| Value | Count | Frequency (%) |
| -36.60537441 | 4 | < 0.1% |
| -32.07951338 | 18 | < 0.1% |
| -31.77241287 | 2 | < 0.1% |
| -31.32151917 | 1 | < 0.1% |
| -30.1594693 | 76 | |
| -30.1100209 | 19 | < 0.1% |
| -30.10330372 | 6 | < 0.1% |
| -30.09981943 | 5 | < 0.1% |
| -30.08061351 | 5 | < 0.1% |
| -30.07200824 | 48 |
| Value | Count | Frequency (%) |
| -2.546079234 | 401 | |
| -3.135622683 | 3 | < 0.1% |
| -3.719036598 | 14 | < 0.1% |
| -3.723306129 | 3 | < 0.1% |
| -3.723672447 | 1 | < 0.1% |
| -3.743987899 | 4 | < 0.1% |
| -3.759209507 | 1 | < 0.1% |
| -3.769923 | 34 | < 0.1% |
| -3.780360995 | 12 | < 0.1% |
| -3.783814827 | 16 | < 0.1% |
| Distinct | 2203 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -47.24790942 |
| Minimum | -67.8096558 |
|---|---|
| Maximum | -34.84785618 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 115037 |
| Negative (%) | 100.0% |
| Memory size | 898.9 KiB |
Quantile statistics
| Minimum | -67.8096558 |
|---|---|
| 5-th percentile | -51.39151634 |
| Q1 | -48.83154738 |
| median | -46.75521082 |
| Q3 | -46.51808197 |
| 95-th percentile | -43.30459253 |
| Maximum | -34.84785618 |
| Range | 32.96179962 |
| Interquartile range (IQR) | 2.313465411 |
Descriptive statistics
| Standard deviation | 2.346335751 |
|---|---|
| Coefficient of variation (CV) | -0.0496600967 |
| Kurtosis | 4.851139313 |
| Mean | -47.24790942 |
| Median Absolute Deviation (MAD) | 0.7668289084 |
| Skewness | 0.5590092336 |
| Sum | -5435257.755 |
| Variance | 5.505291455 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -48.83154738 | 8200 | 7.1% |
| -46.75521082 | 2119 | 1.8% |
| -49.39562407 | 2085 | 1.8% |
| -46.51808197 | 1877 | 1.6% |
| -47.65736585 | 1665 | 1.4% |
| -46.37448953 | 1542 | 1.3% |
| -46.70188324 | 1532 | 1.3% |
| -46.55547279 | 1460 | 1.3% |
| -46.61056007 | 1257 | 1.1% |
| -46.76073521 | 1241 | 1.1% |
| Other values (2193) | 92059 |
| Value | Count | Frequency (%) |
| -67.8096558 | 1 | < 0.1% |
| -64.28394646 | 4 | < 0.1% |
| -63.88797299 | 6 | < 0.1% |
| -61.95720116 | 8 | < 0.1% |
| -60.02346888 | 3 | < 0.1% |
| -57.08632042 | 1 | < 0.1% |
| -56.10296014 | 52 | |
| -56.06797233 | 37 | |
| -55.49644289 | 56 | |
| -54.96989318 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| -34.84785618 | 1 | < 0.1% |
| -34.8557625 | 6 | < 0.1% |
| -34.89678629 | 3 | < 0.1% |
| -34.89853108 | 14 | < 0.1% |
| -34.90155285 | 1 | < 0.1% |
| -34.91839939 | 6 | < 0.1% |
| -34.93222646 | 384 | |
| -35.12509238 | 15 | < 0.1% |
| -35.20164321 | 23 | < 0.1% |
| -35.20826027 | 16 | < 0.1% |
| Distinct | 95840 |
|---|---|
| Distinct (%) | 83.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| eef5dbca8d37dfce6db7d7b16dd0525e | 63 |
|---|---|
| 7145a6f0d38ec713897856cbdcfcdb7f | 38 |
| f28281373ab8815bafafe371218f02ce | 29 |
| 8823bba1e3301fee652eb06de8ef9435 | 26 |
| b5292206f96cd5d97359940203a0b510 | 24 |
| Other values (95835) |
Length
| Max length | 32 |
|---|---|
| Median length | 32 |
| Mean length | 32 |
| Min length | 32 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 83179 ? |
|---|---|
| Unique (%) | 72.3% |
Sample
| 1st row | a54f0611adc9ed256b57ede6b6eb5114 |
|---|---|
| 2nd row | a54f0611adc9ed256b57ede6b6eb5114 |
| 3rd row | a54f0611adc9ed256b57ede6b6eb5114 |
| 4th row | b46f1e34512b0f4c74a72398b03ca788 |
| 5th row | dc90f19c2806f1abba9e72ad3c350073 |
Common Values
| Value | Count | Frequency (%) |
| eef5dbca8d37dfce6db7d7b16dd0525e | 63 | 0.1% |
| 7145a6f0d38ec713897856cbdcfcdb7f | 38 | < 0.1% |
| f28281373ab8815bafafe371218f02ce | 29 | < 0.1% |
| 8823bba1e3301fee652eb06de8ef9435 | 26 | < 0.1% |
| b5292206f96cd5d97359940203a0b510 | 24 | < 0.1% |
| cc074f1c33940c4f0dd904705f98e39e | 24 | < 0.1% |
| b0c2f8c122ebef9f77753f7d167cf634 | 24 | < 0.1% |
| b79b22bb50f78f1afe361661011fd892 | 24 | < 0.1% |
| 7e568736c98c553aea896a5dca746d5a | 22 | < 0.1% |
| 6fe49ee0a2b00dddf7ebddb5847f9283 | 21 | < 0.1% |
| Other values (95830) | 114742 |
Length
| Value | Count | Frequency (%) |
| eef5dbca8d37dfce6db7d7b16dd0525e | 63 | 0.1% |
| 7145a6f0d38ec713897856cbdcfcdb7f | 38 | < 0.1% |
| f28281373ab8815bafafe371218f02ce | 29 | < 0.1% |
| 8823bba1e3301fee652eb06de8ef9435 | 26 | < 0.1% |
| b5292206f96cd5d97359940203a0b510 | 24 | < 0.1% |
| cc074f1c33940c4f0dd904705f98e39e | 24 | < 0.1% |
| b0c2f8c122ebef9f77753f7d167cf634 | 24 | < 0.1% |
| b79b22bb50f78f1afe361661011fd892 | 24 | < 0.1% |
| 7e568736c98c553aea896a5dca746d5a | 22 | < 0.1% |
| e8236fe7b6e1bdd513a500de361e2b87 | 21 | < 0.1% |
| Other values (95830) | 114742 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
review_score
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| 5 | |
|---|---|
| 4 | |
| 1 | |
| 3 | |
| 2 | 4005 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 4 |
|---|---|
| 2nd row | 4 |
| 3rd row | 4 |
| 4th row | 4 |
| 5th row | 5 |
Common Values
| Value | Count | Frequency (%) |
| 5 | 65048 | |
| 4 | 21844 | 19.0% |
| 1 | 14475 | 12.6% |
| 3 | 9665 | 8.4% |
| 2 | 4005 | 3.5% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 5 | 65048 | |
| 4 | 21844 | 19.0% |
| 1 | 14475 | 12.6% |
| 3 | 9665 | 8.4% |
| 2 | 4005 | 3.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 4455 |
|---|---|
| Distinct (%) | 32.4% |
| Missing | 101302 |
| Missing (%) | 88.1% |
| Memory size | 898.9 KiB |
| Recomendo | 487 |
|---|---|
| recomendo | 400 |
| Bom | 327 |
| super recomendo | 309 |
| Excelente | 291 |
| Other values (4450) |
Length
| Max length | 26 |
|---|---|
| Median length | 11 |
| Mean length | 12.18340007 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 3049 ? |
|---|---|
| Unique (%) | 22.2% |
Sample
| 1st row | Cortina de qualidade |
|---|---|
| 2nd row | Cumpriu com o pro |
| 3rd row | pessimo atendimento |
| 4th row | Muito bom os produtos |
| 5th row | Muito bom os produtos |
Common Values
| Value | Count | Frequency (%) |
| Recomendo | 487 | 0.4% |
| recomendo | 400 | 0.3% |
| Bom | 327 | 0.3% |
| super recomendo | 309 | 0.3% |
| Excelente | 291 | 0.3% |
| Muito bom | 278 | 0.2% |
| Ótimo | 267 | 0.2% |
| Super recomendo | 252 | 0.2% |
| Ótimo | 234 | 0.2% |
| Otimo | 201 | 0.2% |
| Other values (4445) | 10689 | 9.3% |
| (Missing) | 101302 |
Length
| Value | Count | Frequency (%) |
| recomendo | 2431 | 9.3% |
| produto | 1534 | 5.9% |
| bom | 1502 | 5.7% |
| muito | 1033 | 3.9% |
| super | 1028 | 3.9% |
| não | 901 | 3.4% |
| ótimo | 797 | 3.0% |
| excelente | 761 | 2.9% |
| entrega | 691 | 2.6% |
| recebi | 429 | 1.6% |
| Other values (2070) | 15100 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 35020 |
|---|---|
| Distinct (%) | 71.9% |
| Missing | 66357 |
| Missing (%) | 57.7% |
| Memory size | 898.9 KiB |
| Muito bom | 253 |
|---|---|
| Bom | 206 |
| muito bom | 133 |
| bom | 115 |
| Otimo | 114 |
| Other values (35015) |
Length
| Max length | 208 |
|---|---|
| Median length | 54 |
| Mean length | 70.24172145 |
| Min length | 1 |
Characters and Unicode
| Total characters | 6736 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 28603 ? |
|---|---|
| Unique (%) | 58.8% |
Sample
| 1st row | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. |
|---|---|
| 2nd row | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. |
| 3rd row | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. |
| 4th row | Deveriam embalar melhor o produto. A caixa veio toda amassada e vou dar de presente. |
| 5th row | Só achei ela pequena pra seis xícaras ,mais é um bom produto |
Common Values
| Value | Count | Frequency (%) |
| Muito bom | 253 | 0.2% |
| Bom | 206 | 0.2% |
| muito bom | 133 | 0.1% |
| bom | 115 | 0.1% |
| Otimo | 114 | 0.1% |
| Recomendo | 109 | 0.1% |
| otimo | 103 | 0.1% |
| Ok | 86 | 0.1% |
| Ótimo | 85 | 0.1% |
| Ótimo | 82 | 0.1% |
| Other values (35010) | 47394 | |
| (Missing) | 66357 |
Length
| Value | Count | Frequency (%) |
| o | 21976 | 3.8% |
| produto | 20397 | 3.5% |
| e | 19319 | 3.3% |
| a | 14683 | 2.5% |
| de | 14025 | 2.4% |
| do | 12741 | 2.2% |
| não | 12650 | 2.2% |
| que | 10090 | 1.7% |
| prazo | 9213 | 1.6% |
| muito | 8894 | 1.5% |
| Other values (19275) | 439767 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6736 |
Most occurring categories
| Value | Count | Frequency (%) |
| Control | 6736 |
Most frequent character per category
Control
| Value | Count | Frequency (%) |
| 6736 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 6736 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 6736 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6736 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 6736 |
| Distinct | 632 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| 2017-12-19 00:00:00 | 531 |
|---|---|
| 2018-05-22 00:00:00 | 515 |
| 2018-05-15 00:00:00 | 514 |
| 2017-12-20 00:00:00 | 502 |
| 2018-05-19 00:00:00 | 500 |
| Other values (627) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 25 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2017-10-11 00:00:00 |
|---|---|
| 2nd row | 2017-10-11 00:00:00 |
| 3rd row | 2017-10-11 00:00:00 |
| 4th row | 2017-08-19 00:00:00 |
| 5th row | 2017-08-08 00:00:00 |
Common Values
| Value | Count | Frequency (%) |
| 2017-12-19 00:00:00 | 531 | 0.5% |
| 2018-05-22 00:00:00 | 515 | 0.4% |
| 2018-05-15 00:00:00 | 514 | 0.4% |
| 2017-12-20 00:00:00 | 502 | 0.4% |
| 2018-05-19 00:00:00 | 500 | 0.4% |
| 2018-08-28 00:00:00 | 497 | 0.4% |
| 2018-05-04 00:00:00 | 495 | 0.4% |
| 2018-03-29 00:00:00 | 490 | 0.4% |
| 2018-03-30 00:00:00 | 477 | 0.4% |
| 2018-08-14 00:00:00 | 476 | 0.4% |
| Other values (622) | 110040 |
Length
| Value | Count | Frequency (%) |
| 00:00:00 | 114942 | |
| 2017-12-19 | 531 | 0.2% |
| 2018-05-22 | 515 | 0.2% |
| 2018-05-15 | 514 | 0.2% |
| 2017-12-20 | 502 | 0.2% |
| 2018-05-19 | 500 | 0.2% |
| 2018-08-28 | 497 | 0.2% |
| 2018-05-04 | 495 | 0.2% |
| 2018-03-29 | 490 | 0.2% |
| 2018-03-30 | 477 | 0.2% |
| Other values (624) | 110611 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 95685 |
|---|---|
| Distinct (%) | 83.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 898.9 KiB |
| 2017-08-17 22:17:55 | 63 |
|---|---|
| 2017-10-19 21:08:44 | 38 |
| 2017-05-24 16:21:27 | 29 |
| 2017-06-28 18:49:50 | 26 |
| 2018-03-07 15:08:10 | 24 |
| Other values (95680) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 82913 ? |
|---|---|
| Unique (%) | 72.1% |
Sample
| 1st row | 2017-10-12 03:43:48 |
|---|---|
| 2nd row | 2017-10-12 03:43:48 |
| 3rd row | 2017-10-12 03:43:48 |
| 4th row | 2017-08-20 15:16:36 |
| 5th row | 2017-08-08 23:26:23 |
Common Values
| Value | Count | Frequency (%) |
| 2017-08-17 22:17:55 | 63 | 0.1% |
| 2017-10-19 21:08:44 | 38 | < 0.1% |
| 2017-05-24 16:21:27 | 29 | < 0.1% |
| 2017-06-28 18:49:50 | 26 | < 0.1% |
| 2018-03-07 15:08:10 | 24 | < 0.1% |
| 2017-03-23 08:34:13 | 24 | < 0.1% |
| 2017-08-01 13:20:31 | 24 | < 0.1% |
| 2018-06-04 19:04:20 | 24 | < 0.1% |
| 2017-12-22 20:33:52 | 22 | < 0.1% |
| 2018-06-15 19:25:55 | 21 | < 0.1% |
| Other values (95675) | 114742 |
Length
| Value | Count | Frequency (%) |
| 2018-05-20 | 768 | 0.3% |
| 2018-05-21 | 677 | 0.3% |
| 2018-05-10 | 582 | 0.3% |
| 2017-12-20 | 464 | 0.2% |
| 2018-04-13 | 421 | 0.2% |
| 2018-05-11 | 410 | 0.2% |
| 2018-08-24 | 410 | 0.2% |
| 2017-12-13 | 410 | 0.2% |
| 2017-12-22 | 407 | 0.2% |
| 2017-12-21 | 402 | 0.2% |
| Other values (53254) | 225123 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| order_id | customer_id | order_status | order_purchase_timestamp | order_approved_at | order_delivered_carrier_date | order_delivered_customer_date | order_estimated_delivery_date | order_item_id | product_id | seller_id | shipping_limit_date | price | freight_value | seller_zip_code_prefix | seller_city | seller_state | customer_unique_id | customer_zip_code_prefix | customer_city | customer_state | product_category_name | product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | payment_sequential | payment_type | payment_installments | payment_value | product_category_name_english | geolocation_lat_customer | geolocation_lng_customer | geolocation_lat_seller | geolocation_lng_seller | review_id | review_score | review_comment_title | review_comment_message | review_creation_date | review_answer_timestamp | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | e481f51cbdc54678b7cc49136f2d6af7 | 9ef432eb6251297304e76186b10a928d | delivered | 2017-10-02 10:56:33 | 2017-10-02 11:07:15 | 2017-10-04 19:55:00 | 2017-10-10 21:25:13 | 2017-10-18 00:00:00 | 1 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-10-06 11:07:15 | 29.99 | 8.72 | 9350 | maua | SP | 7c396fd4830fd04220f754e42b4e5bff | 3149 | sao paulo | SP | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | 1 | credit_card | 1 | 18.12 | housewares | -23.574809 | -46.587471 | -23.680114 | -46.452454 | a54f0611adc9ed256b57ede6b6eb5114 | 4 | NaN | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. | 2017-10-11 00:00:00 | 2017-10-12 03:43:48 |
| 1 | e481f51cbdc54678b7cc49136f2d6af7 | 9ef432eb6251297304e76186b10a928d | delivered | 2017-10-02 10:56:33 | 2017-10-02 11:07:15 | 2017-10-04 19:55:00 | 2017-10-10 21:25:13 | 2017-10-18 00:00:00 | 1 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-10-06 11:07:15 | 29.99 | 8.72 | 9350 | maua | SP | 7c396fd4830fd04220f754e42b4e5bff | 3149 | sao paulo | SP | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | 3 | voucher | 1 | 2.00 | housewares | -23.574809 | -46.587471 | -23.680114 | -46.452454 | a54f0611adc9ed256b57ede6b6eb5114 | 4 | NaN | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. | 2017-10-11 00:00:00 | 2017-10-12 03:43:48 |
| 2 | e481f51cbdc54678b7cc49136f2d6af7 | 9ef432eb6251297304e76186b10a928d | delivered | 2017-10-02 10:56:33 | 2017-10-02 11:07:15 | 2017-10-04 19:55:00 | 2017-10-10 21:25:13 | 2017-10-18 00:00:00 | 1 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-10-06 11:07:15 | 29.99 | 8.72 | 9350 | maua | SP | 7c396fd4830fd04220f754e42b4e5bff | 3149 | sao paulo | SP | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | 2 | voucher | 1 | 18.59 | housewares | -23.574809 | -46.587471 | -23.680114 | -46.452454 | a54f0611adc9ed256b57ede6b6eb5114 | 4 | NaN | Não testei o produto ainda, mas ele veio correto e em boas condições. Apenas a caixa que veio bem amassada e danificada, o que ficará chato, pois se trata de um presente. | 2017-10-11 00:00:00 | 2017-10-12 03:43:48 |
| 3 | 128e10d95713541c87cd1a2e48201934 | a20e8105f23924cd00833fd87daa0831 | delivered | 2017-08-15 18:29:31 | 2017-08-15 20:05:16 | 2017-08-17 15:28:33 | 2017-08-18 14:44:43 | 2017-08-28 00:00:00 | 1 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-08-21 20:05:16 | 29.99 | 7.78 | 9350 | maua | SP | 3a51803cc0d012c3b5dc8b7528cb05f7 | 3366 | sao paulo | SP | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | 1 | credit_card | 3 | 37.77 | housewares | -23.565578 | -46.534603 | -23.680114 | -46.452454 | b46f1e34512b0f4c74a72398b03ca788 | 4 | NaN | Deveriam embalar melhor o produto. A caixa veio toda amassada e vou dar de presente. | 2017-08-19 00:00:00 | 2017-08-20 15:16:36 |
| 4 | 0e7e841ddf8f8f2de2bad69267ecfbcf | 26c7ac168e1433912a51b924fbd34d34 | delivered | 2017-08-02 18:24:47 | 2017-08-02 18:43:15 | 2017-08-04 17:35:43 | 2017-08-07 18:30:01 | 2017-08-15 00:00:00 | 1 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-08-08 18:37:31 | 29.99 | 7.78 | 9350 | maua | SP | ef0996a1a279c26e7ecbd737be23d235 | 2290 | sao paulo | SP | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | 1 | credit_card | 1 | 37.77 | housewares | -23.543295 | -46.630743 | -23.680114 | -46.452454 | dc90f19c2806f1abba9e72ad3c350073 | 5 | NaN | Só achei ela pequena pra seis xícaras ,mais é um bom produto\r\n | 2017-08-08 00:00:00 | 2017-08-08 23:26:23 |
| 5 | bfc39df4f36c3693ff3b63fcbea9e90a | 53904ddbea91e1e92b2b3f1d09a7af86 | delivered | 2017-10-23 23:26:46 | 2017-10-25 02:14:11 | 2017-10-27 16:48:46 | 2017-11-07 18:04:59 | 2017-11-13 00:00:00 | 1 | 87285b34884572647811a353c7ac498a | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-10-31 02:14:11 | 29.99 | 14.10 | 9350 | maua | SP | e781fdcc107d13d865fc7698711cc572 | 88032 | florianopolis | SC | utilidades_domesticas | 40.0 | 268.0 | 4.0 | 500.0 | 19.0 | 8.0 | 13.0 | 1 | boleto | 1 | 44.09 | housewares | -27.536913 | -48.509018 | -23.680114 | -46.452454 | 1bafb430e498b939f258b9c9dbdff9b1 | 3 | NaN | NaN | 2017-11-08 00:00:00 | 2017-11-10 19:52:38 |
| 6 | 5f49f31e537f8f1a496454b48edbe34d | a7260a6ccba78544ccfaf43f920b7240 | delivered | 2017-08-24 11:31:28 | 2017-08-24 11:45:25 | 2017-08-25 14:17:55 | 2017-08-28 20:12:20 | 2017-09-14 00:00:00 | 2 | be03d93320192443b8fa24c0ca6ead98 | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-08-30 11:45:25 | 46.80 | 67.70 | 9350 | maua | SP | 7a1de9bde89aedca8c5fbad489c5571c | 1315 | sao paulo | SP | utilidades_domesticas | 59.0 | 189.0 | 3.0 | 775.0 | 16.0 | 16.0 | 13.0 | 1 | credit_card | 1 | 127.45 | housewares | -23.552593 | -46.640683 | -23.680114 | -46.452454 | 8899ca945efd951c97107b4966289227 | 1 | NaN | Prezados que porcaria de atendimento ao cliente não se consegue falar com um atendente, só uma máquina burra e ignorante.\r\nVocês não me enviaram o kit de vedação da cafeteira e o filtro e se só isso n | 2017-08-29 00:00:00 | 2017-08-30 02:26:02 |
| 7 | 5f49f31e537f8f1a496454b48edbe34d | a7260a6ccba78544ccfaf43f920b7240 | delivered | 2017-08-24 11:31:28 | 2017-08-24 11:45:25 | 2017-08-25 14:17:55 | 2017-08-28 20:12:20 | 2017-09-14 00:00:00 | 1 | d4a3b5aa064bf44e74f1e71862bea22a | 57c764b4a836300be881e2ff86e449f9 | 2017-08-30 11:45:25 | 9.90 | 3.05 | 14021 | ribeirao preto | SP | 7a1de9bde89aedca8c5fbad489c5571c | 1315 | sao paulo | SP | utilidades_domesticas | 59.0 | 236.0 | 1.0 | 100.0 | 21.0 | 9.0 | 13.0 | 1 | credit_card | 1 | 127.45 | housewares | -23.552593 | -46.640683 | -21.212279 | -47.788152 | 8899ca945efd951c97107b4966289227 | 1 | NaN | Prezados que porcaria de atendimento ao cliente não se consegue falar com um atendente, só uma máquina burra e ignorante.\r\nVocês não me enviaram o kit de vedação da cafeteira e o filtro e se só isso n | 2017-08-29 00:00:00 | 2017-08-30 02:26:02 |
| 8 | 1fa40f202d5d233b6491e976c557b822 | 50fd5707c28d0a64dc20d67f937dd9ba | delivered | 2017-09-23 22:11:10 | 2017-09-23 22:25:11 | 2017-09-26 17:27:54 | 2017-10-19 21:09:21 | 2017-11-13 00:00:00 | 1 | 8415b1dae10d2dcb36beec370c6a90cd | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-09-27 22:25:11 | 28.90 | 21.15 | 9350 | maua | SP | 35c6ec4630637b3ec0da6e587f245f83 | 69043 | manaus | AM | utilidades_domesticas | 59.0 | 322.0 | 5.0 | 600.0 | 24.0 | 5.0 | 18.0 | 1 | credit_card | 1 | 50.05 | housewares | -3.076345 | -59.936005 | -23.680114 | -46.452454 | 4b70092fc12f2328972d5ff1022d87e9 | 4 | NaN | NaN | 2017-10-20 00:00:00 | 2017-10-23 04:13:41 |
| 9 | 41c045db2d1876be9f05cf4a787693b2 | a286f46d6e54cc0179bbb0ee07b0df5e | delivered | 2017-08-16 14:06:30 | 2017-08-16 14:55:20 | 2017-08-18 15:41:40 | 2017-08-21 15:05:13 | 2017-08-29 00:00:00 | 1 | 5e18248fc768bdb7fc69fd012068d109 | 3504c0cb71d7fa48d967e0e4c94d59d9 | 2017-08-22 14:55:20 | 24.90 | 7.78 | 9350 | maua | SP | 4e4fa2b85379e9db6dc59f873f0a9748 | 5640 | sao paulo | SP | utilidades_domesticas | 37.0 | 749.0 | 4.0 | 600.0 | 16.0 | 6.0 | 20.0 | 1 | credit_card | 1 | 32.68 | housewares | -23.627053 | -46.736376 | -23.680114 | -46.452454 | b9e086024ceb0234e5950016497a4928 | 5 | NaN | NaN | 2017-08-22 00:00:00 | 2017-08-26 02:31:53 |
Last rows
| order_id | customer_id | order_status | order_purchase_timestamp | order_approved_at | order_delivered_carrier_date | order_delivered_customer_date | order_estimated_delivery_date | order_item_id | product_id | seller_id | shipping_limit_date | price | freight_value | seller_zip_code_prefix | seller_city | seller_state | customer_unique_id | customer_zip_code_prefix | customer_city | customer_state | product_category_name | product_name_lenght | product_description_lenght | product_photos_qty | product_weight_g | product_length_cm | product_height_cm | product_width_cm | payment_sequential | payment_type | payment_installments | payment_value | product_category_name_english | geolocation_lat_customer | geolocation_lng_customer | geolocation_lat_seller | geolocation_lng_seller | review_id | review_score | review_comment_title | review_comment_message | review_creation_date | review_answer_timestamp | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 115027 | 8dde389ebcf87898f96614bf718a3424 | 7f9a771719afa6802825b9f0793d980f | delivered | 2018-08-14 10:41:49 | 2018-08-14 10:50:16 | 2018-08-22 08:00:00 | 2018-08-28 19:39:37 | 2018-09-05 00:00:00 | 1 | 09c85a316aae843ab464c8c55d6f8b80 | 5f57db27027655e6c6a391601daa0258 | 2018-08-20 10:50:16 | 98.00 | 53.04 | 29138 | viana | ES | acc0e3b063cb014e3ef92b08b5836bcf | 75131 | anapolis | GO | automotivo | 25.0 | 728.0 | 1.0 | 850.0 | 25.0 | 25.0 | 25.0 | 1 | credit_card | 10 | 151.04 | auto | -16.374258 | -48.978557 | -20.371678 | -40.420102 | d41fb2b7b7606e0bc39eddd56dea3bea | 5 | NaN | NaN | 2018-08-29 00:00:00 | 2018-08-30 09:42:55 |
| 115028 | ac284fb15053d666dfb6128354f0e662 | 7a4e42927347804cbbc5b584d003bef6 | delivered | 2018-08-22 14:14:50 | 2018-08-22 14:25:19 | 2018-08-22 13:46:00 | 2018-08-28 21:32:27 | 2018-09-14 00:00:00 | 1 | cde7eb02af6868b9904f1ea2c7fdfdc3 | b19c48688808720822399ffa9f2dbe2f | 2018-08-28 14:25:19 | 959.99 | 24.82 | 4801 | sao paulo | SP | 7f7e4fd22c2dd6ef9fdbf6431a6878a0 | 29936 | sao mateus | ES | relogios_presentes | 56.0 | 398.0 | 3.0 | 500.0 | 20.0 | 30.0 | 20.0 | 1 | credit_card | 8 | 984.81 | watches_gifts | -18.730463 | -39.845664 | -23.713324 | -46.698514 | 67094d46bcdebac20f73bdac807c9bac | 5 | NaN | NaN | 2018-08-29 00:00:00 | 2018-08-30 14:13:03 |
| 115029 | f2d6c25c24dec1cb1f8eeba2203634b5 | 57244724368844b9ccf59f216d2bb822 | delivered | 2018-08-12 20:58:54 | 2018-08-12 21:15:11 | 2018-08-13 15:25:00 | 2018-08-24 17:38:34 | 2018-09-12 00:00:00 | 1 | 73dacc49330dc5cc9b1c1983c16200e7 | ccbd753e6863fe7314dc6c0ca5a074e7 | 2018-08-16 21:15:11 | 495.00 | 101.56 | 89046 | blumenau | SC | 74da9bfeaa1c29dc1e5b3a07a4ec17a2 | 58410 | campina grande | PB | automotivo | 54.0 | 299.0 | 1.0 | 5450.0 | 40.0 | 16.0 | 30.0 | 1 | credit_card | 6 | 596.56 | auto | -7.241552 | -35.882677 | -26.922717 | -49.148206 | d71d9f67138ec03bfc0a7e6ccfd6046c | 4 | Muito bom | NaN | 2018-08-25 00:00:00 | 2018-08-27 03:05:19 |
| 115030 | 3cd99c2644261f4b3bf7f70f67e4b5f2 | d9ef74a91ad65ba313ff15f78c65159d | delivered | 2017-10-20 08:49:05 | 2017-10-20 09:06:10 | 2017-10-23 14:23:55 | 2017-11-11 14:04:56 | 2017-11-22 00:00:00 | 1 | e058c61cf68327217d4bc8b13d07cd64 | fa8d335d68129e464e60c1826a683e96 | 2017-10-26 09:06:10 | 139.90 | 34.78 | 95660 | tres coroas | RS | fd358179adc6171c9c6c51e0d91e6b68 | 70845 | brasilia | DF | automotivo | 37.0 | 2036.0 | 1.0 | 600.0 | 17.0 | 10.0 | 24.0 | 1 | credit_card | 10 | 174.68 | auto | -15.774459 | -47.876779 | -29.517802 | -50.765754 | 395474ca46cc360bedc6e58ebc585c4a | 4 | NaN | NaN | 2017-11-12 00:00:00 | 2017-11-13 13:06:51 |
| 115031 | 8cca5f9f04056cb2d8abb9b845e89b62 | 7573237856d19beef367370dd2285f37 | delivered | 2018-05-12 07:21:13 | 2018-05-12 07:35:42 | 2018-05-14 14:59:00 | 2018-05-18 20:44:31 | 2018-06-04 00:00:00 | 1 | 2307240c5347bb41a709a1ab8e38b5ff | 2c538755f1ca9540af144f266e70df6c | 2018-05-17 07:35:12 | 334.99 | 24.92 | 39801 | castro pires | MG | 077c6658adbb60fcf8437e255c00e906 | 12095 | taubate | SP | automotivo | 57.0 | 372.0 | 4.0 | 2150.0 | 28.0 | 28.0 | 38.0 | 1 | credit_card | 6 | 359.91 | auto | -23.075220 | -45.538807 | -17.851690 | -41.493610 | 1a6fe9277fca69b72022e71be4833f36 | 5 | NaN | NaN | 2018-05-19 00:00:00 | 2018-05-20 16:21:35 |
| 115032 | a37e262a26000281d0ade3b4eb1ce1e6 | d0602b514179e7ed50e801cc02769bac | delivered | 2018-08-06 23:14:27 | 2018-08-06 23:25:19 | 2018-08-07 14:16:00 | 2018-08-13 19:08:40 | 2018-08-22 00:00:00 | 1 | 987ae6d6e94a608f9ea32bc82a649470 | 466222e777149751370e7e98fb623b0c | 2018-08-08 23:25:19 | 87.90 | 17.55 | 20931 | rio de janeiro | RJ | ce05c653348a8e630ebbb1fd1e0968d2 | 74080 | goiania | GO | automotivo | 60.0 | 1469.0 | 4.0 | 550.0 | 36.0 | 8.0 | 15.0 | 1 | credit_card | 10 | 105.45 | auto | -16.689245 | -49.259284 | -22.876270 | -43.212926 | bf0ab4c039d6b05f116d3b9a97344e09 | 5 | NaN | NaN | 2018-08-14 00:00:00 | 2018-08-15 10:33:03 |
| 115033 | 8edaa376e19d08bc84ab8845682216b4 | 4c1e29ec2ed2feac441cf24b25262ed2 | delivered | 2018-04-24 08:37:20 | 2018-04-24 17:26:25 | 2018-04-25 12:24:00 | 2018-05-10 22:36:37 | 2018-05-14 00:00:00 | 1 | b0498e44190727b728ae4490f2e9b6a5 | dda37071807e404c5bb2a1590c66326f | 2018-04-30 09:30:37 | 199.99 | 19.28 | 3282 | sao paulo | SP | 913a4e0cb7fe555e6cffa875ecd58e2e | 28455 | sao jose de uba | RJ | malas_acessorios | 25.0 | 712.0 | 4.0 | 5250.0 | 34.0 | 23.0 | 40.0 | 1 | credit_card | 1 | 219.27 | luggage_accessories | -21.358247 | -41.941457 | -23.590854 | -46.541398 | 7bbe7636141510158aa577dcfd017b13 | 5 | NaN | NaN | 2018-05-11 00:00:00 | 2018-05-13 00:12:43 |
| 115034 | e9f8c67129c6f0bf411b428141ddfbf5 | b364fc9218a7e1ddd9eb23124ebb7d86 | delivered | 2017-04-11 22:09:31 | 2017-04-12 13:10:17 | 2017-04-17 10:26:59 | 2017-04-30 06:57:43 | 2017-05-12 00:00:00 | 1 | ecb624b552f939e58c7881de58ece085 | 0936e1837d0c79253456bbb2ffaaef10 | 2017-04-26 13:10:17 | 19.45 | 15.56 | 2050 | sao paulo | SP | 11d76022677f3753f19633e2fd0470c3 | 35995 | sao domingos do prata | MG | ferramentas_jardim | 57.0 | 314.0 | 1.0 | 900.0 | 62.0 | 3.0 | 13.0 | 1 | credit_card | 7 | 70.02 | garden_tools | -19.871369 | -42.960859 | -23.516544 | -46.610563 | 95df327760017d154c5f6364e06d70eb | 5 | NaN | NaN | 2017-05-01 00:00:00 | 2017-05-03 16:38:56 |
| 115035 | e9f8c67129c6f0bf411b428141ddfbf5 | b364fc9218a7e1ddd9eb23124ebb7d86 | delivered | 2017-04-11 22:09:31 | 2017-04-12 13:10:17 | 2017-04-17 10:26:59 | 2017-04-30 06:57:43 | 2017-05-12 00:00:00 | 2 | ecb624b552f939e58c7881de58ece085 | 0936e1837d0c79253456bbb2ffaaef10 | 2017-04-26 13:10:17 | 19.45 | 15.56 | 2050 | sao paulo | SP | 11d76022677f3753f19633e2fd0470c3 | 35995 | sao domingos do prata | MG | ferramentas_jardim | 57.0 | 314.0 | 1.0 | 900.0 | 62.0 | 3.0 | 13.0 | 1 | credit_card | 7 | 70.02 | garden_tools | -19.871369 | -42.960859 | -23.516544 | -46.610563 | 95df327760017d154c5f6364e06d70eb | 5 | NaN | NaN | 2017-05-01 00:00:00 | 2017-05-03 16:38:56 |
| 115036 | 815ba48fd172b6a71f09180c118a31ca | 626da291c796ef2695981deb0bbc9eed | processing | 2017-09-15 13:24:29 | 2017-09-16 03:06:14 | NaN | NaN | 2017-10-09 00:00:00 | 1 | 41f9d5d764dc0fa4928c9177275e5763 | 5aaa890629f83706d8d9bfecd8377c1c | 2017-09-21 03:06:14 | 48.90 | 17.92 | 25720 | petropolis | RJ | 2dad8f2b565b14983d2792369429b34f | 95950 | nova brescia | RS | construcao_ferramentas_construcao | 42.0 | 251.0 | 1.0 | 400.0 | 16.0 | 16.0 | 16.0 | 1 | boleto | 1 | 66.82 | construction_tools_construction | -29.213983 | -52.031601 | -22.436244 | -43.140338 | 3f93f4f7f09c312dce86e2fb8a4d4430 | 1 | NaN | NaN | 2017-10-12 00:00:00 | 2017-10-14 03:44:41 |